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

Did you do it with ignore=y??

If not, have another go. Ignore=y means 'when you try and create something which is already there, I know you will get an error. Please just ignore that error and get on with the juicy business of doing the inserts of data, which is all I am really interested in'.

"Ignore=y", rather fortunately, has brevity on its side.

Regards
HJR "Tim Lee" <timothy.yw.lee_at_philips.com> wrote in message news:9877ck$aih112_at_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:25:09 CST