Is anybody know how to move the tables or indexes from one tablespace to another tablespace ?
export, drop TB and IDX. Create in you desired TBS with the same name. import
do a simple create table table_name as select * from table
hope this helps
alter table move
Make use of the ALTER TABLE MOVE command.
Make sure you rebuild the indexes on the table.
It makes the table's indexes UNUSABLE
Click Here to Expand Forum to Full Width