Database cloning using Full Expdp and Impdp
hi,
I would like to clone the database using expdp/impdp ( as per the client request)
I need to export entire database from "source" and import to another host (target) ,where same database name already exists. (but few schemas does not exist on target and I want to override all user schemas, there are more than 20 schemas). I have SQL user with SYSADMIN privilege on both the databases.
Can I use the following steps:
full export: (on source)
expdp <user>/<pwd> dumpfile=full_export.dmp logfile=full_export_log.log directory=dmpdir full=yes
Import: (on target)
impdb <user>/<pwd> dumpfile=full_export.dmp logfile=full_import_log.log directory=dmpdir full=yes ignore=YES