Oracle Database Data Pump Step 7 : Export Commands
Example
Commands:
expdp <bkpadmin>/<bkp123> parfile=<exp.par>
*Please replace the data in <> with appropriate values as per your environment. You can add/modify parameters as per your requirements. In the above example all the remaining parameters are added in parameter files as stated below: *
- Export Type : User Export
- Export entire schema
- Parameter file details [say exp.par] :
schemas=<schema>
directory= DATAPUMP_REMOTE_DIR
dumpfile=<dbname>_<schema>.dmp
logfile=exp_<dbname>_<schema>.log
- Export Type : User Export for large schema
- Export entire schema for large datasets: Here the export dump files will be broken down and compressed. Parallelism is used here (Note : Adding parallelism will increase the CPU load on server)
- Parameter file details [say exp.par] :
schemas=<schema>
directory= DATAPUMP_REMOTE_DIR
dumpfile=<dbname>_<schema>_%U.dmp
logfile=exp_<dbname>_<schema>.log
compression = all
parallel=5
- Export Type : Table Export [ Export set of tables]
- Parameter file details [say exp.par] :
tables= tname1, tname2, tname3
directory= DATAPUMP_REMOTE_DIR
dumpfile=<dbname>_<schema>.dmp
logfile=exp_<dbname>_<schema>.log
