Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

create instance from dump file

clliranMay 6 2011 — edited May 16 2011

Hi all,
I need to create new instance from dump file which was created with expdp. There are some problems\doubts:
1. i have several production instances on my server and dont wanna crush them.
2. the dump file was generated from instance ‘name _1’ and i want to create instance ‘name_2’.i mean that i must create new catalog for all files (data files, contrl files, archive redo logs, redo logs and etc). New instance must have new unique parameters. How can I do this?
3. how should be parameters of impdp if expdp was like this:
expdp system/*****@SID full=Y dumpfile=mydump.dmp directory=my_directory logfile=mylogfile.log JOB_NAME=FULLexp

thanks and regards,
rustam

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 13 2011

Added on May 6 2011

#database-key-features, #export-import-sql-loader-external-tables

9 comments

1,250 views