Oracle EMP/imp

E:/> exp help = y

By entering the exp command and user name/password, you can
Command after user/password:

Example: EXP Scott/Tiger

Alternatively, you can control the running mode of "Export" by entering the exp command with various parameters. Svplinux Alliance
To specify parameters, you can use the Keyword:

Format: EXP keyword = value or keyword = (value1, value2,..., valuen) svplinux Alliance
Instance: EXP Scott/tiger grants = y tables = (EMP, DEPT, MGR) svplinux Alliance
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) svplinux Alliance
--------------------------------------------------- Svplinux Alliance
Userid username/password svplinux Alliance
Full export the entire file (n) svplinux Alliance
Buffer data buffer size svplinux Consortium
Owner owner username list svplinux Alliance
File output file (expdat. dmp) svplinux Alliance
Tables Table Name List svplinux Alliance
Compress imports a range (y) svplinux Alliance
Length of recordlength Io record svplinux Alliance
Grants export permission (y) svplinux Alliance
Inctype incremental export type svplinux Alliance
Indexes export index (y) svplinux Alliance
Record tracking incremental Export (y) svplinux Alliance
Rows export data rows (y) svplinux Alliance
Parfile parameter file name svplinux Alliance
Constraints export limit (y) svplinux Alliance
Consistent cross tabulation consistency svplinux Alliance
Svplinux
Statistics Analysis object (estimate) svplinux Alliance
Direct direct path (n) svplinux Alliance
Triggers export trigger (y) svplinux Alliance
Feedback displays the progress of each X row (0) svplinux Alliance
Filesize maximum size of each dump file svplinux Alliance
Query the clause of the selected export table subset

The following keywords are only used for the table space svplinux Union that can be transferred
Transport_tablespace export writable tablespace metadata (n) svplinux Alliance
Table space list of tablespaces to be transmitted

Svplinux Alliance
E:/> imp help = y

You can enter the IMP command and your user name/password svplinux Alliance
Command with your username/password:

Instance: IMP Scott/Tiger

Alternatively, you can control "import" by entering the IMP command and various independent variables according to different parameters. Svplinux Alliance
To specify parameters, you can use the Keyword:

Format: IMP keyword = value or keyword = (value1, value2,..., vlauen) svplinux Alliance
Instance: IMP Scott/tiger ignore = y tables = (EMP, Dept) Full = nsvplinux Alliance
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) svplinux Alliance
---------------------------------------------- Svplinux Alliance
Userid username/password svplinux Alliance
Full import the entire file (n) svplinux Alliance
Buffer data buffer size svplinux Consortium
Fromuser owner username list svplinux Alliance
File input file (expdat. dmp) svplinux Alliance
Touser username list svplinux Alliance
Show only list file content (n) svplinux Alliance
Tables Table Name List svplinux Alliance
Ignore ignore creation error (n) svplinux Alliance
Length of recordlength Io record svplinux Alliance
Grants import permission (y) svplinux Alliance
Inctype incremental Import Type svplinux Alliance
Indexes import index (y) svplinux Alliance
Commit submits array insertion (n) svplinux Alliance
Rows import data row (y) svplinux Alliance
Parfile parameter file name svplinux Alliance
Svplinux
Constraints import restrictions (y) svplinux Alliance
Destroy overwrite the tablespace data file (n) svplinux Alliance
Indexfile writes table/index information to the specified file svplinux Alliance
Skip_unusable_indexes skip maintenance of unavailable indexes (n) svplinux Alliance
Analyze executes the analyze Statement (y) svplinux union in the dump file
Feedback displays the progress of each X row (0) svplinux Alliance
Toid_novalidate skips the validation svplinux alliance for the specified type ID
Filesize maximum size of each dump file svplinux Alliance
Recalculate_statistics recalculates the statistical value (N)

The following keywords are only used for the table space svplinux Union that can be transferred
Transport_tablespace import writable tablespace metadata (n) svplinux Alliance
Tablespaces tablespace to be transmitted to the database svplinux Alliance
Data files to be transmitted to the database svplinux Alliance
Tts_owners has users who can transmit table space centralized data.