Oracle export help

Oracle export help [SQL] by entering the IMP command and your username/password, the import operation will prompt you to enter the parameter: www.2cto.com For example: IMP SCOTT/TIGER or, you can control the import running mode by entering the IMP command and various parameters. To specify parameters, you can use the KEYWORD: Format: imp keyword = value or KEYWORD = (value1, value2 ,..., valueN) for example: imp scott/tiger ignore = y tables = (EMP, DEPT) FULL = N or TABLES = (T1: P1, T1: P2 ), if T1 is the Partition Table USERID, it must be the first parameter in the command line. Keyword description (default value) keyword description (default value) -------------------------------------------------------------------------- USERID username/password FULL import the entire FILE (N) BUFFER data BUFFER size FROMUSER owner username list FILE input FILE (EXPDAT. DMP) TOUSER username list SHOW only list file content (N) TABLES Table Name List IGNORE creation error (N) recordlength io record length GRANTS import permission (Y) INCTYPE incremental import type INDEXES import index (Y) COMMIT submit array insert (N) ROWS import data row (Y) PARFILE parameter file name LOG screen output LOG File CONSTRAINTS import limit (Y) D ESTROY overwrites the tablespace data file (N) INDEXFILE to write table/index information to the specified file SKIP_UNUSABLE_INDEXES to skip maintenance of unavailable indexes (N) FEEDBACK displays progress (0) per x rows) TOID_NOVALIDATE skips verification FILESIZE of the specified type ID. maximum size of each dump. STATISTICS always imports pre-calculated STATISTICS. RESUMABLE suspends when space-related errors occur (N) RESUMABLE_NAME is used to identify the text string RESUMABLE_TIMEOUT RESUMABLE of the recoverable statement. The COMPILE process is COMPILE, and the general metadata of the package and function (Y) STREAMS_CONFIGURATION imported stream (Y) STREAMS_INSTANTIATION import stream instantiation metadata (N) the following keywords are only used for the transferred tablespace TRANSPORT_TAB LESPACE import the writable tablespace metadata (N) TABLESPACES the tablespace DATAFILES to be transmitted to the database the data files to be transmitted to the database TTS_OWNERS users who have the ability to transmit the data in the tablespace set are successfully terminated for import, no warning is displayed.