Oracle EXP / IMP arguments detailed
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 |
Related Posts of Oracle EXP / IMP arguments detailed
-
ORACLE table space-related operations
sqlplus / nolog connect / as sysdba startup sqlplus / nolog connect / as sysdba SHUTDOWN IMMEDIATE If you want to use windows default date format. English is not in the configuration variables in the environment: NLS_LANG american_america.us7ASCII - ...
-
Oracle Database exp imp Import Export by user examples
◆ 1. From one windows server A on Test1 export all objects in the user, and then into the linux server B on Test2 users. (Test1 known password for the system users Test1passwd or export is required) ◆ 2.B user Test2 machine does not exist, or Test2 b ...
-
Oracle database used to maintain day-to-day command
Oracle database used to maintain day-to-day command At run-time Oracle database, DBA should run the database log and table space for the use of surveillance, early detection of problems that exist in the database. One, Oracle log file monitoring warn ...
-
Oracle Database Exp / Imp tools for performance tuning
Abstract: Oracle Exp / Imp instrument is a simple, convenient and flexible backup and restore data transfer tool, it can implement the entire class library, user-level, table-class data backup and recovery. For the amount of data in class G or G with ...
-
Oracle to create data table space, the user, authorization, table, index, cluster
/ / Create a temporary table space (log files) create temporary tablespace test_temp tempfile 'E: \ oracle \ test_temp01.dbf' size 32m autoextend on next 32m maxsize 2048m extent management local; / / Create a data table space create tablespa ...
-
oracle database backup and restore
Oracle Database Backup and Recovery This article comes from the Internet, thanks authors. When we use a database, always hoped that the content of the database is reliable and correct, but because of the failure of computer systems (including equipme ...
-
Oracle10g ASM database table space maintenance
1. Default naming Oracle when using ASM + OMF management, Oracle distribution file name will automatically create the appropriate file. Our job to create table space can be simplified as follows: A command. The following are the default Oracle naming ...
-
Block Oracle paragraph (reprint)
Starting today, begin reading the second oracle document b10743, "conceps"; do not know can give me a new harvest. The master was oracle's Michele Cyran characters written by people such as cow, a really good book. Alas English not well ...













Leave a Reply