Oracle alter table tablespace

1. Find out which tables have incorrect tablespaces.

 

Select * From dba_tables where tablespace_name = 'tdb ';

 

 

2. Move the tablespace in TDB to tdb2009.

Syntax: alter table table_name move tablespace tablespace_name;

 

Alter table tdb2009.assoc _ INFO move tablespace tdb2009;
Alter table tdb2009.bguserpopd move tablespace tdb2009;

 

Close

 

Select 'alter index tdb2009. '| index_name | 'rebuild online nologging tablespace tdb2009;' from user_indexes

 

Supplement:

 

In Oracle, how does one change all indexes in one tablespace to another?
Select 'alter Index' | index_name | 'move tablespace tdb2009; 'from user_indexes