[Import] Oracle Import and Export command line

C: \ imp-help

Import: Release 9.2.0.1.0-Production on Friday July 4 10:18:55 2008

Copyright (c) 1982,200 2, oracle Corporation. All rights reserved.

You can enter the IMP command and your username/password.
Command followed by user name/password:

Routine: imp scott/TIGER

Alternatively, you can control "import" by entering the IMP command and various parameters"
According to different parameters. To specify parameters, you can use the Keyword:

Format: imp keyword = value or KEYWORD = (value1, value2,..., vlaueN)
Routine: imp scott/tiger ignore = y tables = (EMP, DEPT) FULL = N
Or TABLES = (T1: P1, T1: P2). If T1 is a partitioned table

USERID must be the first parameter in the command line.

Keyword description (default) keyword description (default)
--------------------------------------------------------------------------
USERID username/password FULL import the entire file (N)
BUFFER data BUFFER size FROMUSER User Name List
FILE input FILE (EXPDAT. DMP) TOUSER username list
SHOW only lists the file content (N) TABLES Table names
IGNORE ignores creation error (N) recordlength io record length
GRANTS import permission (Y) INCTYPE incremental Import Type
INDEXES import index (Y) COMMIT submit array insert (N)
ROWS import data row (Y) PARFILE parameter file name
Restrictions on importing LOG files output by LOG screens (Y)
Destroy overwrite the tablespace data file (N)
Indexfile writes table/index information to the specified file
Skip_unusable_indexes skips maintenance of unavailable indexes (N)
The progress of feedback is displayed on every X rows (0)
Toid_novalidate skips the verification of the specified type ID
Filesize: maximum size of each dump.
Statistics always imports pre-calculation statistics
When a space error occurs, the resumable suspends (n)
Resumable_name is a text string used to identify recoverable statements.
The waiting time of RESUMABLE_TIMEOUT RESUMABLE.
COMPILE compilation process, package and function (Y)
STREAMS_CONFIGURATION import the General metadata of Streams (Y)
STREAMS_INSTANITATION import the instantiation metadata of Streams (N)

The following keywords are only used for table spaces that can be transferred.
TRANSPORT_TABLESPACE import the deletable tablespace metadata (N)
TABLESPACES tablespace to be transmitted to the database
Data files to be transmitted to the database
TTS_OWNERS has users who can transmit table space centralized data.

Import is terminated successfully, but a warning is displayed.

 

C: \ exp-help

Export: Release 9.2.0.1.0-Production on Friday July 4 10:21:38 2008

Copyright (c) 1982,200 2, oracle Corporation. All rights reserved.

By entering the EXP command and user name/password, you can
Command followed by user name/password:

Routine: exp scott/TIGER

Alternatively, you can control "Export" by entering the EXP command with various parameters"
According to different parameters. To specify parameters, you can use the Keyword:

Format: EXP keyword = value or keyword = (value1, value2,..., valuen)
Routine: EXP Scott/tiger grants = y tables = (EMP, DEPT, MGR)
Or tables = (T1: P1, T1: P2). If T1 is a partitioned table

Userid must be the first parameter in the command line.

Keyword description (default) keyword description (default)
--------------------------------------------------------------------------
Userid username/password full export the entire file (N)
Buffer data buffer size owner User Name List
File output file (expdat. dmp) tables Table Name List
Length of the IO record that compress imports to a partition (y) recordlength
GRANTS export permission (Y) INCTYPE incremental export type
INDEXES export index (Y) RECORD trace incremental Export (Y)
DIRECT path (N) TRIGGERS export trigger (Y)
The LOG file STATISTICS analysis object (ESTIMATE) output by the LOG Screen)
ROWS export data row (Y) PARFILE parameter file name
CONSISTENT cross tabulation consistency (N) CONSTRAINTS exported by CONSTRAINTS (Y)

OBJECT_CONSISTENT only sets transaction processing to read during object Export (N)
Progress of each row of FEEDBACK (0)
FILESIZE: maximum size of each dump.
FLASHBACK_SCN is used to set the session snapshot back to the previous state SCN
FLASHBACK_TIME is used to obtain the SCN time closest to the specified time.
QUERY: select clause used to export a subset of a table
When the RESUMABLE encounters a space-related error, it suspends (N)
RESUMABLE_NAME is a text string used to identify a recoverable statement.
The waiting time of RESUMABLE_TIMEOUT RESUMABLE.
TTS_FULL_CHECK performs a complete or partial correlation check on TTS.
Table space list of TABLESPACES to Be Exported
TRANSPORT_TABLESPACE export the table space metadata that can be transferred (N)
TEMPLATE: name of the TEMPLATE to be exported in iAS mode.

The export is successfully terminated without warning.

Source: http://Jorkin.Reallydo.Com/default.asp? Id = 530