Export or Import Database Oracle (expdp, impdp)

On oracle the following is an example of the table export and import syntax.

Export Table Code :

expdp <userschema>/<passwordschema> table=<tablename> 
directory=<directoryname> dumpfile=<filedmpname>.dmp 
logfile=<filelogname>.log

Export Schema Code :

expdp <userschema>/<passwordschema> schemas=<schemaname> 
directory=<directoryname> dumpfile=<filedmpname>.dmp 
logfile=<filelogname>.log

Export Full Code :

expdp <userschema>/<passwordschema> full=Y 
directory=<directoryname> dumpfile=<filedmpname>.dmp 
logfile=<filelogname>.log

Import Table Code :

impdp <userschema>/<passwordschema> table=<tablename> 
directory=<directoryname> dumpfile=<filedmpname>.dmp 
logfile=<filelogname>.log

Import Schema Code :

impdp <userschema>/<passwordschema> schemas=<schemaname> 
directory=<directoryname> dumpfile=<filedmpname>.dmp 
logfile=<filelogname>.log

Import Full Code :

impdp <userschema>/<passwordschema> full=Y 
directory=<directoryname> dumpfile=<filedmpname>.dmp 
logfile=<filelogname>.log

www.diarycoding.com

Leave a Comment.