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

Report message to a moderator

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: 4963
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.

Report message to a moderator

Previous Topic: Data Pump issue
Next Topic: Errors Migrating from oracle 9i enterprise edition to oracle 10g r2 standard
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 23 20:20:11 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.