-
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
-
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
hptse
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|