Friday, August 2, 2013

Export or Import Oracle Database

To Import


  • For full database import open Command Prompt
> imp USERNAME/PASSWORD@SERVICENAME file='path' FULL='Y'

Example: imp scott/tiger@orcl file='D:\sales.dmp' full='Y'


  • For importing a specific schema open command prompt 
> impdp USERNAME/PASSWORD@SERVICENAME schemas=SCHEMA_NAME directory=DIRECTORY_NAME dumpfile=FILE_NAME logfile=LOGFILE.log


Example: impdp cmro/cmro@orcl schemas=CMRO directory=temp_dir dumpfile=cmro.dmp logfile=cmroexpdp.log

To Export


  • For full database export open Command Prompt

> exp USERNAME/PASSWORD@SERVICENAME file='path' FULL='Y'

Example: exp scott/tiger@orcl file='D:\sales.dmp' full='Y'


  • For exporting a specific schema open command prompt 
> expdp USERNAME/PASSWORD@SERVICENAME schemas=SCHEMA_NAME directory=DIRECTORY_NAME dumpfile=FILE_NAME logfile=LOGFILE.log


Example: expdp cmro/cmro@orcl schemas=CMRO directory=temp_dir dumpfile=cmro.dmp logfile=cmroexpdp.log


To know how to create a database directory see this


1 comment:

  1. I NEED SUPPLIER2 DMP FILE IF ANYONE HAVE IT PLEASE PROVIDE IT.I NEED IT URGENT

    ReplyDelete