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:
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
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
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
Comments