Posts Tagged ‘ datapump table ’

Oracle Datapump Various Scenario/Examples

I collected this content from this link.

Let’s experiment expdp & impdp utility for different scenarios. We have two database orcl, ordb. All the below scenarios are tested in Oracle10g R2 version.

Scenario 1 :

Export the whole orcl database.

Export Parfile content:

userid=system/password@orcl
dumpfile=expfulldp.dmp
logfile=expfulldp.log
full=y
directory=dumplocation Continue reading

Advertisements

Datapump import/Export Tables/Schemas

For specific table import from datapump backup use this script. it will truncate existing one.


impdp system/*** tables=sibl.account remap_schema=sibl:jan28 directory=backup_dir
dumpfile=ABABIL.28Jan2012.02.38PM.dmp logfile=imp_log_of_28012012.log 
TABLE_EXISTS_ACTION=TRUNCATE remap_tablespace=temp:ababil_temp_ts,UNDOTBS1:ABABIL_UNDO_TS

To import whole schema use this one.


impdp system/****** schemas=sibl,ababilfe remap_schema=sibl:month41,ababilfe:monthfe41
directory=backup_dir dumpfile=ABABIL.26Apr2011.09.04PM.dmp logfile=imp_log_of_260411.log
remap_tablespace=temp:ababil_temp_ts,UNDOTBS1:ABABIL_UNDO_TS

Thanks
A Rahim Khan

Advertisements