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

To fix the tablespace problem, just precreate the tablespaces in the locations and with the filenames you want. When the import runs, it will detect that the tablespaces are already created and it will skip that step!

HTH,
Brian

Tim Lee wrote:
>
> 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!
> > ========================================
 

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================