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

Home -> Community -> Usenet -> c.d.o.tools -> Re: After I done a Full Export of my database, how do I move this database to another database with a different instance name

Re: After I done a Full Export of my database, how do I move this database to another database with a different instance name

From: Tim Lee <timothy.yw.lee_at_philips.com>
Date: Thu, 8 Mar 2001 14:02:14 +0800
Message-ID: <9877ck$aih112@imsp212.netvigator.com>

Hi Brian:

I tried your method, but it doesn't seems to work. When I look at the import.log,it tried to create tablespace in the same location as the production database, in which these files already exist, which result in error.

"Brian Peasland" <peasland_at_usgs.gov> wrote in message news:3AA645AE.E55906FE_at_usgs.gov...
> Tim,
>
> You can just do a full import into your test database. The fact that it
> is a different instance name does not make any difference!
>
> Set up your TNSNAMES file with entries to both of your databases (if not
> previously done). Then do the following:
> 1) exp userid=u/p_at_prod full=y file=exp.dmp
> 2) imp userid=u/p_at_test full=y file=exp.dmp
>
> That's all there is to it!
>
> HTH,
> Brian
>
>
> Tim Lee wrote:
> >
> > Dear all:
> >
> > I have two Oracle instances reside on my NT server
> >
> > One is for production, and one is for testing.
> >
> > Now I would like to move my entire production database to my testing
> > database.
> > So I have done a full database export of my production database
> >
> > But I realise that now when I do the full import to my testing database,
> > because the tesing database have a different instance name as the
 production
> > one, it will try to re-create all these objects in the production
 database
> > during the import.
> >
> > What should I do to move all objects form my production database to the
> > testing database?
> >
> > Thanks for all your help in advance!
>
> --
> ========================================
> Brian Peasland
> Raytheons Systems at
> USGS EROS Data Center
> These opinions are my own and do not
> necessarily reflect the opinions of my
> company!
> ========================================
Received on Thu Mar 08 2001 - 00:02:14 CST

Original text of this message

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