Data pump Export (expdp) patt #1

Data Pump Export is a utility for unloading data and metadata into a set of operating system files called a dump file set. The dump file set can be imported only by the Data Pump Import utility. The dump file set can be imported on the same system or it can be moved to another system and
loaded there.

The dump file set is made up of one or more disk files that contain table data, database object metadata, and control information. The files are written in a proprietary, binary format.

Invoking Data Pump Export : The Data Pump Export utility is invoked using the expdp command. The characteristics of the export operation are determined by the Export parameters you specify. These parameters can be specified either on the command line or in a parameter file.

Data Pump Export Interfaces: You can interact with Data Pump Export by using a command line, a parameter file, or an interactive-command mode.

1.Command-Line Interface: Enables you to specify most of the Export parameters directly on the command line. Parameters Available in Export's
Command-Line Mode

Parameter	Description	Default
attach	connects a client session to a current running data pump export job
content	filters what is export: data_only, metadata_only , all	all
directory	destination of log and dump files	data_pump_dir
dumpfile	name of the dump file
estimate	method used to estimate dump file size : blocks or statistics
estimate_only	Y/N. instruct data_pump whether data should be exported or estimated.	N
exclude	exclude objects and data from being exported.
filesize	maximum size of each dump file
flashback_scn	scn of the database to flash back to to during exported
flushback_time	timestamp of the database to flash back to to during exported
full	Y/N. export all data and metadata in a full mode export	N
help	Y/N. display a list of avillable commands and options	N
include	specify which objects and data will be exported
job_name	name of the job	system generated
logfile	name of log file	expdp.log
network_link	source database link for a data pump job exporting a remote database
nologfile	a Y/N flag used to suppress log file creation
parallel	set number of workers for the export job	1
parfile	name the parameter file to use
query	filters row from table during the export
schemas	name the schema to be exported for schema mode export
status	displays detailed status of the data pump job
tables	list of tables and partitions to be exported for table mode export
tablespace	list of tablespaces to export in tablespace mode
transport_full_check	Specifies whether the tablespaces being exported should be verified as a self-contained set.
transport_tablespaces	specifies a transportable tablespace mode export
version	specifies the version of the database.

please go to Part 2