Home » RDBMS Server » Server Utilities » Import to a new Database (Oracle 10g)
Import to a new Database [message #424901] Tue, 06 October 2009 08:09 Go to next message
StefanTA650
Messages: 9
Registered: May 2005
Junior Member
Hello!
I want to make a copy of an existing database for testing. But how to do? My idea is to make a full export first. But in the dump-file are the absolute pathes stored to the original database. So when doing the import I guess that these original datafiles will be used and not my new ones.
Can anyone give me a hint??????

Regards in advance!!

Stefan
Re: Import to a new Database [message #424905 is a reply to message #424901] Tue, 06 October 2009 08:20 Go to previous message
joy_division
Messages: 4616
Registered: February 2005
Location: East Coast USA
Senior Member
You have to create a new database with the same tablespace names, then import and choose to ignore errors.
Previous Topic: Data Pump issue
Next Topic: Errors Migrating from oracle 9i enterprise edition to oracle 10g r2 standard
Goto Forum:
  


Current Time: Tue Sep 27 11:06:27 CDT 2016

Total time taken to generate the page: 0.10669 seconds