Skip to Main Content

Oracle Database Discussions

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!

Copy a database to another database

894590Oct 21 2011 — edited Oct 24 2011
Hi all

I dont work much with databases so my knowledge in Db is limited.

My objective is : to create a safe-backup- copy of exisitng database and work on new copy for modifications.

I have this huge database with some tables having blob columns.

I tried using exp and expdp to export and then imp/impdp the database but i run into issues.
Sometimes some tables are skipped (with blob columns)

I was looking at some clone or duplcate commands that could help me.


What is the easiest way to copy a database?

my purpose is just to keep old copy safe.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 21 2011
Added on Oct 21 2011
5 comments
223 views