Hi,
Is anybody know how to move the tables or indexes from one tablespace to another tablespace ?
Thanks
Printable View
Hi,
Is anybody know how to move the tables or indexes from one tablespace to another tablespace ?
Thanks
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
tablespace desired_tablespace;
hope this helps
Make use of the ALTER TABLE MOVE command.
Make sure you rebuild the indexes on the table.
It makes the table's indexes UNUSABLE