Wednesday, January 21, 2015

Oracle Import/Export .dmp selecting the Schmeas you want

Here is how you export

logged as oracle user run:
expdp schemas=SCHEMA_CATA,SCHEMA_CATB,SCHEMA_CORE,SCHEMA_PUB directory=DATA_PUMP_DIR dumpfile=MySchemas.DMP logfile=SCHEMA_expdp.log
Where:

  • schemas is the list of schemas to export
  • directory is where you want the dmp to be created, along with the log file
  • logfile the name of the log file

If just need the DDLs just add the following parameter to the above expdp command rows=n

It will ask for your system credentials.

The dmp will go to /admin/orcl/dpdump/ which is the value that DATA_PUMP_DIR, this can be changed on the DB

When is done you will see the following message:

Master table "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded

Import the .dmp is very similar, just do as follows
impdp schemas=SCHEMA_CATA,SCHEMA_CATB,SCHEMA_CORE,SCHEMA_PUB directory=DATA_PUMP_DIR dumpfile=MySchemas.DMP logfile=SCHEMA_impdp.log

Post a Comment