From: rled@izb-soft.de (Richard Ledwon)
Subject: Re: [Q] Can I rename TABLESPACE ?
Date: 1996/11/22
Message-ID: <574e1g$dcq@izb.izb-soft.de>#1/1
references: <32952EBA.C54@usa.net>
organization: IZB Soft
reply-to: rled@izb-soft.de
newsgroups: comp.databases.oracle



Huy Vu <huyv@usa.net> wrote:

>We have 2 databases A & B. The only different between them is:
 
>A was created tablespace with the name USER and B was created tablespace
>name USERDATA.
 
>Can I rename USER tablespace in A to USERDATA before import the dumpfile
>from B?

In A, you can drop tablespace USER and then recreate it as USERDATA. 
Any users/schemas with objects in the old tablespace USER must be
recreated with "default tablespace USERDATA". The import will then put
any objects, that used to be in USER, into USERDATA.

Hope this is of help.

--
Richard Ledwon
rled@izb-soft.de