1. Common Import and Export commands:imp (Import), exp (export)
CMD-based Export import:
Key words |
Note |
Userid |
User name/password |
Full |
Export entire file (N) |
BUFFER |
Size of the data buffer |
OWNER |
List of owner user names |
FILE |
Output file (Expdat. DMP) |
TABLES |
List of table names |
COMPRESS |
Import a range (Y) |
RecordLength |
Length of IO record |
GRANTS |
Export Permissions (Y) |
Inctype |
Incremental export Type |
INDEXES |
Export Index (Y) |
RECORD |
Trace incremental Export (Y) |
ROWS |
Export data rows (Y) |
Parfile |
Parameter file name |
CONSTRAINTS |
Export Limit (Y) |
Consistent |
Cross-table consistency |
LOG |
Log file for screen output |
STATISTICS |
Analytical Objects (ESTIMATE) |
DIRECT |
Direct Path (N) |
TRIGGERS |
Export Trigger (Y) |
FEEDBACK |
Shows the progress of each x line (0) |
FILESIZE |
Maximum size of each dump file |
QUERY |
Select the clause that exports a subset of tables |
The following keywords are only available for transportable tablespaces |
Transport_tablespace |
Export the transportable tablespace metadata (N) |
Tablespaces |
List of table spaces to transfer |
IMP parameter details
Used in the format: IMP keyword=value or keyword= (value1,value2,..., Valuen)
Where UserID is required and is the first parameter
Key words |
Note |
Userid |
User name/password |
Full |
Import entire file (N) |
BUFFER |
Data buffer size |
Fromuser |
List of owner user names |
Touser |
List of user names |
FILE |
Input file (Expdat. DMP) |
SHOW |
List only file contents (N) |
TABLES |
List of table names |
IGNORE |
Ignore create error (N) |
RecordLength |
Length of IO record |
GRANTS |
Import permissions (Y) |
Inctype |
Incremental import Type |
INDEXES |
Import index (Y) |
COMMIT |
Commit array insertion (N) |
ROWS |
Import data rows (Y) |
Parfile |
Parameter file name |
LOG |
Log file for screen output |
CONSTRAINTS |
Import Limit (Y) |
DESTROY |
Overwrite tablespace data file (N) |
Indexfile |
Writes table/index information to the specified file |
Skip_unusable_indexes |
Skipping maintenance of indexes that are not available (N) |
FEEDBACK |
Show progress per X line (0) |
Toid_novalidate |
Skipping validation of a specified type ID |
FILESIZE |
Maximum size of each dump file |
STATISTICS |
Always import precomputed statistics |
Resumable |
Hang (N) when encountering space-related errors |
Resumable_name |
The text string used to identify the recoverable statement |
Resumable_timeout |
Resumable of waiting time |
COMPILE |
Compilation procedures, packages and functions (Y) |
Streams_configuration |
Generic metadata for the import stream (Y) |
Streams_instantiation |
Import Stream instantiation metadata (N) |
The following keywords are only available for transportable tablespaces |
Transport_tablespace |
Import transportable tablespace metadata (N) |
Tablespaces |
Table space to be transferred to the database |
Datafiles |
Data files that will be transferred to the database |
Tts_owners |
Users who have data in a dataset that can transmit a table space |
Oracle export, import parameters explained