Re: Relocate Tablespace

From: Ramamohan B N <ramamohan.bn_at_tatainfotech.com>
Date: Wed, 13 Dec 2000 16:50:40 +0530
Message-Id: <10709.124424@fatcity.com>

Hi Nosie,

Take an export dump of the user whose objects you want to relocate. Create the user on the second database and make quota zero for system tablespace. Assign the the tablespace to which you want to move these objects as the default TBS and import the export dump file.

This will for a single user and when there are no constraints refering to the objects of different user. I THINK U HAVE MANUALLY SET THESE CONSTRAINTS. Regards,
Mohan

Nosie wrote:
>
> 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 Wed Dec 13 2000 - 05:20:40 CST