Copy a database to another database
894590Oct 21 2011 — edited Oct 24 2011Hi 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.