Data pump export (expdp) and import (impdp) examples

July 30, 2012 admin Oracle

Export parfile:
userid=”/ as sysdba”
directory=COG83_EXPORT
dumpfile=cog83_export_092710.dmp
logfile=cog83_export_092710.log
parallel=4
compression=none
content=ALL
schemas=cog_cm,cog_log

Import parfile:
userid=”/ as sysdba”
directory=COG83_EXPORT
dumpfile=cog83_export_092710.dmp
logfile=cog83_import_092710.log
parallel=4
remap_schema=cog_log:cog_log_83
remap_schema=cog_cm:cog_cm_83
remap_tablespace=data_cog_log:data_cog_log_83
remap_tablespace=data_cog_cm:data_cog_cm_83
remap_tablespace=data_lob_cog_cm:data_lob_cog_cm_83

Get CLOB sizes show_users.sql