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

From: Agi <agichen_at_my-deja.com>
Date: Tue, 18 Jan 2000 04:59:20 GMT
Message-ID: <860rv1$g28$1@nnrp1.deja.com>

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 - 22:59:20 CST