Re: rename of exported database
Date: 1995/12/22
Message-ID: <30DB048C.200B_at_ccm.tdsnet.com>#1/1
Please give more details of what you want to achieve. If you want to import data of a user i.e. tables and indexes owned by a schema, to another user or schema, it is possible by using the fromuser and touser options of import. Import will not insist you to have same instance
name. Import doesnot bother the name of the instance while importing data. Your problem may be to import the data of a user into another user. This is possible. However, you will have to do the import for eachuser separately and you will have to create the new user in the new database before you import the data.
If you need more details, please send me an email.
Thanks
Vijay Nair
Vincent Usaraga wrote:
>
> I recently exported an entire Oracle database and need to
> import it to another oracle database with another name.
>
> Has anyone done this before? I am cloning this system
> so we can practice with the clone data on another machine
> with of course another database name.
>
> I tried an oracle export and then import, but oracle
> insists we use the same name.
>
> Any help is greatly appreciated. Thank you
>
> Vince usaraga_at_ix.netcom.com
Received on Fri Dec 22 1995 - 00:00:00 CET