-
Move a number of tables in a tablespace
Planning to move more than 200 tables in an existing tablespaceTS_big. Will the command like below looping thru all tables work:
alter table tab_name move tablesspace TS_big
Only doubt I have it is an EXISTING tablespace where we want to consolidate all tables.
-
Hmm when some of us is trying to distribute tables across several tablespaces and you are trying to put everything in the same tablespace, interesting
Just rememebr rebuild all your 200 tables indexes after move your tables
-
I am trying to move all tablespaces of all partitions of A TABLE in a tablespace. I have 200 tablespsaces per TABLE for last 5 years historical data. I am trying to see what problems I may have in my plans.
So, probs I see:
Target tablepsace should be big - I have big datafiles with autoextent turned on, this should solve this. No need to calculate totla size of TS etc.
Indexes- Not sure how to move them as they are in seperate tablespace, alsoe moving them will validate them automatically?
-
alter index xxx rebuild tablespace yyy;
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
|