OraFAQ Forum: Server Utilities » Import to a new Database

Home » RDBMS Server » Server Utilities » Import to a new Database (Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Import to a new Database [message #424901]

Tue, 06 October 2009 08:09

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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jan 20 06:04:48 CST 2026