Datapump – Hands on

DBv11.2.0.3.0
Case-1 import backup when you don’t know username

SQLFILE : Write all the SQL DDL to a specified file.

-bash-4.1$ impdp userid=system/manager remap_schema=rm:appgt directory=DB_BKP dumpfile=exp_appgt_11051606200101.dmp SQLFILE=rm.sql

REMAP_TABLESPACE: Tablespace objects are remapped to another tablespace.
REMAP_SCHEMA: Objects from one schema are loaded into another schema.
EXCLUDE=TABLE:”IN(‘EDR’,’CORESESSIONS’,’SESSIONRULE’)”

impdp userid=system/manager remap_schema=QM:netvertexgt directory=DB_BKP dumpfile=exp_netvertex_11051606200101.dmp remap_tablespace=QM:netvertexgt EXCLUDE=TABLE:”IN(‘EDR’,’CORESESSIONS’,’SESSIONRULE’)” TABLE_EXISTS_ACTION=REPLACE

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s