Database Utilities (MOSC)

MOSC Banner

Database cloning using Full Expdp and Impdp

edited Sep 19, 2017 9:12AM in Database Utilities (MOSC) 13 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center