relocating tables and indexes and S.A.F.E. Script/ideas anyone?
Hello
I'm planning to relocate all tables and indexes to new tablespaces. I am doin' so because of the S.A.F.E. rules.
The only problems is: there are many tables and indexes and relocating them by hand is a lot of work.
My question:
Does anyone have a script/tool that intelligently chooses the right tablespace for an object? If the result is a 'alter table/index rebuild online tablespace "x"; ' script, then it would be perfect.
If there isn't a script, can someone explain me how I can determine the right TS?
I know that the newer versions of TOAD can generate such a script, but this is a creation script, not a relocate script.
Thanks in advance,
Erik
Last edited by efrijters; 09-02-2003 at 05:55 AM.
An expert is one who knows more and more about less and less until he knows absolutely everything about nothing.
Reply With Quote