E: /> Exp Help = Y
You can by entering the exp command and username / password
Command after the user / password:
Example: EXP Scott / Tiger
Alternatively, you can also control the "Export" operating mode by entering the EXP command with various parameters.
To specify parameters, you can use keywords:
Format: exp keyword = value or keyword = (Value1, Value2, ..., Valuen)
Example: EXP Scott / Tiger GRANTS = y Tables = (EMP, DEPT, MGR)
Or TABLES = (T1: P1, T1: P2), if T1 is a partition table
UserID must be the first parameter in the command line.
Keyword description (default)
-------------------------------------------------- -
UserID username / password
Full exports the entire file (N)
Buffer data buffer size
Owner owner username list
File output file (Expdat.dmp)
TABLES Table Name List
Compress imports a range (Y)
Recordlength IO length
GRANTS Export Permissions (Y)
IncType incremental export type
Indexes Export Index (Y)
RECORD Tracking Increase (Y)
Rows Export Data Line (Y)
PARFILE parameter file name
Constraints Export Limit (Y)
Consistent crosses consistency
Log screen output log file
Statistics Analysis Object (Estimate)
Direct Direct Path (N)
Triggers Export Trigger (Y)
Feedback displays the progress of each x row (0)
FileSize's maximum size of each dump file
Query Select the clause of the exported table set
The following keywords are only used for transmissionable tablespaces
Transport_Tablespace exports can be transmitted tablespace metadata (N)
TableSpaces lists the table space listing
E: /> IMP Help = Y
Can pass the IMP command and your username / password
With your username / password command:
Example: IMP Scott / Tiger
Alternatively, "import" can be controlled by inputting the Imp command and various arguments.
To specify parameters, you can use keywords:
Format: IMP keyword = value or keyword = (Value1, Value2, ..., Vlauen)
Example: IMP Scott / Tiger Ignore = y Tables = (EMP, DEPT) FULL = N
Or TABLES = (T1: P1, T1: P2), if T1 is a partition table
UserID must be the first parameter in the command line.
Keyword description (default)
----------------------------------------------
UserID username / password
Full Imports the entire file (n)
Buffer data buffer size
FromUser owner username list
FILE input file (expdat.dmp)
Touser username list
SHOW only lists the file content (n)
TABLES Table Name List
Ignore ignores creation error (n)
Recordlength IO length
GRANTS Import Permissions (Y)
IncType incremental import type
Indexes Import Index (Y)
Commit submission array insertion (N)
ROWS Import Data Line (Y)
PARFILE parameter file name
Log screen output log file
Constraints Import Limit (Y)
Destroy Overwrite Table Space Data File (N)
IndexFile writes the table / index information to the specified file
Skip_unusable_indexes Skip the Maintenance of Unavailable Index (N) Analyze in the Analyze Perform dump file (Y)
Feedback displays the progress of each x row (0)
TOID_NOVALIDATE Skip the verification of the specified type ID
FileSize's maximum size of each dump file
Recalculating statistics (N)
The following keywords are only used for transmissionable tablespaces
Transport_Tablespace Imports Transfer Table Space Metadata (N)
TableSpaces will be transferred to the table space of the database
DataFiles will be transferred to the database data file
TTS_OWNERS has users who can transfer data in the mobile tablespace
