Re: To:senior DBAs ....................

Your 1. is the safest, however you may need to recompile packages/procedures/functions.
Also, remember that all objects owned by a given schema may not be located in 1 tablespace.
Your 2. will not get any other objects. Be careful! Other comercial reorg tools are available which are thorough and fast.

Agi wrote:

> Hello,sirs:
>
> I have a tablespace DATA with 450 tables,I want to drop the
> tablespace and rebuild the tablespace.What's the save & fast way to
> reorg ??
>
> All that I can think is
> 1.export the data,drop the tablespace and re-create the tablespace
> then import.
> 2.another way is using create table as select (CTAS) to another user
> (other tablespace) then drop the tablespace then re-create the tables
> in the new tablespace.
>
> Anything that I should consider ??
> Any suggestions ??
>
> Thanks for any suggestions in advance !!
>
> Agi Chen
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Jan 17 2000 - 23:54:21 CST