Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Relocate Tablespace

Relocate Tablespace

From: Nosie <tekait11_at_bni.co.id>
Date: Wed, 13 Dec 2000 11:38:06 +0700
Message-Id: <10708.124411@fatcity.com>


Hi DBAs,

I plan to redesign a database structure. Currently a production DB has all objects stored in SYSTEM tablespace. I want to move it to a new production DB (in a new server machine) while relocate user objects (tables, indexes, triggers, stored procedures, etc) to tablespaces different than SYSTEM. What is the safest way to do it?

Thanks in advance for your helps... Received on Tue Dec 12 2000 - 22:38:06 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US