Oracle datapump Parameters / Commands

Oracle impdp parameters:

Parameter             	Parameter description
ATTACH                	Attach to existing job, e.g. ATTACH [=job name].
CONTENT            	Specifies data to load where the valid keywords are:(ALL), DATA_ONLY, and METADATA_ONLY.
DIRECTORY          	Directory object to be used for dump, log, and sql files.
DUMPFILE            	List of dumpfiles to import from (expdat.dmp),e.g. DUMPFILE=scott1.dmp, scott2.dmp, dmpdir:scott3.dmp.
ENCRYPTION_PASSWORD   	Password key for accessing encrypted column data.This parameter is not valid for network import jobs.
ESTIMATE              	Calculate job estimates where the valid keywords are:(BLOCKS) and STATISTICS.
EXCLUDE               	Exclude specific object types, e.g. EXCLUDE=TABLE:EMP.
FLASHBACK_SCN    	SCN used to set session snapshot back to.
FLASHBACK_TIME   	Time used to get the SCN closest to the specified time.
FULL                    Import everything from source (Y).
HELP                    Display help messages (N).
INCLUDE               	Include specific object types, e.g. INCLUDE=TABLE_DATA.
JOB_NAME           	Name of import job to create.
LOGFILE               	Log file name (import.log).
NETWORK_LINK          	Name of remote database link to the source system.
NOLOGFILE         	Do not write logfile.
PARALLEL            	Change the number of active workers for current job.
PARFILE               	Specify parameter file.
QUERY                 	Predicate clause used to import a subset of a table.
REMAP_DATAFILE        	Redefine datafile references in all DDL statements.
REMAP_SCHEMA          	Objects from one schema are loaded into another schema.
REMAP_TABLESPACE  	Tablespace object are remapped to another tablespace.
REUSE_DATAFILES       	Tablespace will be initialized if it already exists (N).
SCHEMAS               	List of schemas to import.
SKIP_UNUSABLE_INDEXES 	Skip indexes that were set to the Index Unusable state.
SQLFILE               	Write all the SQL DDL to a specified file.
STATUS                	Frequency (secs) job status is to be monitored where the default (0) will show new status when available.
STREAMS_CONFIGURATION 	Enable the loading of Streams metadata
TABLE_EXISTS_ACTION   	Action to take if imported object already exists.Valid keywords: (SKIP), APPEND, REPLACE and TRUNCATE.
TABLES                  Identifies a list of tables to import.
TABLESPACES           	Identifies a list of tablespaces to import.
TRANSFORM             	Metadata transform to apply to applicable objects.Valid transform keywords: SEGMENT_ATTRIBUTES, STORAGE OID, and PCTSPACE.
TRANSPORT_DATAFILES   	List of datafiles to be imported by transportable mode.
TRANSPORT_FULL_CHECK  	Verify storage segments of all tables (N).
TRANSPORT_TABLESPACES 	List of tablespaces from which metadata will be loaded. Only valid in NETWORK_LINK mode import operations.
VERSION               	Version of objects to export where valid keywords are: (COMPATIBLE), LATEST, or any valid database version.Only valid for NETWORK_LINK and SQLFILE.

You can use the following commands in interactive mode.

Command               Command description
CONTINUE_CLIENT       Return to logging mode. Job will be re-started if idle.
EXIT_CLIENT           Quit client session and leave job running.
HELP                  Summarize interactive commands.
KILL_JOB              Detach and delete job.

PARALLEL              Change the number of active workers for current job.PARALLEL=.
START_JOB             Start/resume current job.START_JOB=SKIP_CURRENT will start the job after skipping any action which was in progress when job was stopped.
STATUS                Frequency (secs) job status is to be monitored where the default (0) will show new status when available.STATUS[=interval]
STOP_JOB              Orderly shutdown of job execution and exits the client. STOP_JOB=IMMEDIATE performs an immediate shutdown of the Data Pump job. 

A Rahim Khan

  1. No trackbacks yet.

Leave a Reply

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

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

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s

%d bloggers like this: