Oracle Command-Line Operations

Exp Zdxk/[email protected] tables= (MS_DATA_DICTORY_DEF,MS_STATIC_DATA_DEF) file=c:\staticdata.dmp

Export by entering the EXP command and your username/password
The action prompts you to enter the parameters:

For example: EXP Scott/tiger

Alternatively, you can control the export by entering an EXP command with various parameters
The operating mode. To specify parameters, you can use keywords:

Format: EXP keyword=value or keyword= (value1,value2,..., Valuen)
For example: EXP scott/tiger grants=y tables= (emp,dept,mgr)
or tables= (T1:P1,T1:P2), if T1 is a partitioned table

The USERID must be the first parameter in the command line.

Keyword description (default) keyword description (default value)
--------------------------------------------------------------------------
USERID username/password Full export entire file (N)
Buffer Data buffer size owner owner user Name list
File output files (expdat. DMP) List of TABLES table names
COMPRESS Import to a zone (Y) RecordLength IO record length
GRANTS Export Permission (Y) Inctype Incremental Export type
INDEXES Export Index (y) RECORD tracking incremental export (Y)
Direct path (N) TRIGGERS export Trigger (Y)
Log screen output STATISTICS Analysis Object (ESTIMATE)
Rows Export data row (Y) parfile parameter file name
Consistent cross-table consistency (N) CONSTRAINTS export Constraints (Y)

Object_consistent only transactions that are set to read-only during object export (N)
FEEDBACK Show progress per x line (0)
FILESIZE maximum size per dump file
FLASHBACK_SCN used to set the session snapshot back to the previous state of the SCN
Flashback_time the time to get the SCN closest to the specified time
QUERY The SELECT clause that is used to export a subset of tables
Resumable hangs when encountering a space-related error (N)
Resumable_name text string used to identify a recoverable statement
Resumable_timeout resumable Waiting time
Tts_full_check performing a full or partial correlation check on TTS
tablespaces List of table spaces to export
Transport_tablespace exporting the Transportable tablespace metadata (N)
Template call IAS schema exported templates name

Oracle Command-Line Operations