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
Messages: 9
Registered: May 2005
Junior Member
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!!

Re: Import to a new Database [message #424905 is a reply to message #424901] Tue, 06 October 2009 08:20 Go to previous message
Messages: 4621
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 Oct 25 01:48:02 CDT 2016

Total time taken to generate the page: 0.18899 seconds