Oracle EXP / IMP arguments detailed
exp / imp is Oracle's own import and export command, use it, even if that statement does not require UI tool can easily export the data into the completion of the work, the following are their parameters:EXP arguments detailed <br /> use format: EXP KEYWORD = value or KEYWORD = (value1, value2 ,..., valueN)
Where USERID is necessary and for the first parameter
| Keyword | Notes |
| USERID | User Name / Password |
| FULL | Exporting the entire file (N) |
| BUFFER | Data buffer size of the |
| OWNER | Owner user name list |
| FILE | Output file (EXPDAT.DMP) |
| TABLES | Table Name List |
| COMPRESS | Into a range of (Y) |
| RECORDLENGTH | Record the length of the IO |
| GRANTS | Export privileges (Y) |
| INCTYPE | Incremental export type |
| INDEXES | Export Index (Y) |
| RECORD | Track incremental export (Y) |
| ROWS | Export data rows (Y) |
| PARFILE | Parameter File Name |
| CONSTRAINTS | Export restriction (Y) |
| CONSISTENT | Cross-table consistency |
| LOG | The screen output log file |
| STATISTICS | Analysis of objects (ESTIMATE) |
| DIRECT | Direct path (N) |
| TRIGGERS | Export triggers (Y) |
| FEEDBACK | Display each x-line (0) the progress of the |
| FILESIZE | The maximum size of each dump file |
| QUERY | Export Table selected subset of the clauses |
| The following keywords are used only for table spaces that can be transmitted | |
| TRANSPORT_TABLESPACE | Export the table that can be transmitted spatial metadata (N) |
| TABLESPACES | The transfer list of the table space |
IMP arguments detailed
The format used is: IMP KEYWORD = value or KEYWORD = (value1, value2 ,..., valueN)
Where USERID is necessary and for the first parameter
| Keyword | Notes |
| USERID | User Name / Password |
| FULL | Import the entire file (N) |
| BUFFER | Data Buffer Size |
| FROMUSER | Owner user name list |
| TOUSER | User Name List |
| FILE | Input file (EXPDAT.DMP) |
| SHOW | List only the contents of the file (N) |
| TABLES | Table Name List |
| IGNORE | Ignore create errors (N) |
| RECORDLENGTH | Record the length of the IO |
| GRANTS | Import permission (Y) |
| INCTYPE | Incremental import type |
| INDEXES | Import Index (Y) |
| COMMIT | Presented an array insert (N) |
| ROWS | Import data rows (Y) |
| PARFILE | Parameter File Name |
| LOG | The screen output log file |
| CONSTRAINTS | Import restrictions (Y) |
| DESTROY | Cover the table space data file (N) |
| INDEXFILE | Table / index information write to the specified file |
| SKIP_UNUSABLE_INDEXES | Skip index maintenance is not available (N) |
| FEEDBACK | Line shows the progress of each x (0) |
| TOID_NOVALIDATE | Skip the specified types of ID verification |
| FILESIZE | The maximum size of each dump file |
| STATISTICS | Always import precomputed statistics |
| RESUMABLE | In the event of space-related error hangs (N) |
| RESUMABLE_NAME | Recoverable statement used to identify text strings |
| RESUMABLE_TIMEOUT | RESUMABLE waiting time |
| COMPILE | Compilation process, package and functions (Y) |
| STREAMS_CONFIGURATION | Flow into the general metadata (Y) |
| STREAMS_INSTANTIATION | Import current instantiation metadata (N) |
| The following keywords are used only for table spaces that can be transmitted | |
| TRANSPORT_TABLESPACE | Import the table that can be transmitted spatial metadata (N) |
| TABLESPACES | Will be transferred to the database table space |
| DATAFILES | Will be transmitted to the database data files |
| TTS_OWNERS | Have a centralized data can be transmitted to the user tablespace |
Tags: STATISTICS estimate always imp exp oracle, oracle imp arguments, oracle imp args, oracle export rows=y, usage of buffer in exp and imp table space, export data, import data, oracle exp, buffer size, import and export, buffer data, imp, cross table, data buffer, clauses, export table, table spaces, maximum size, export command, export privileges, parameter keyword, import index, export index, input file
Permalink: http://www.kods.netwww.kods.net/oracle-exp-imp-arguments-detailed/
















