Oracle Import/Export (imp/exp) command

Oracle Import utility allows you to extract data from a database and write the data to an operating system file.

The basic format used by imp: imp [username [/password [@ service]. The following describes common usage of imp.

1. Get help

Imp help = y

2. Import a complete database

Imp system/manager file = bible_db log = dible_db full = y ignore = y

3. import one or more specified tables, indexes, and other objects to which the user belongs.

Imp system/manager file = seapark log = seapark fromuser = seapark imp

System/manager file = seapark log = seapark fromuser = (seapark, amy, amyc, harold)

4. Import the data of one user to another.

Imp system/manager file = tank log = tank fromuser = seapark touser = seapark_copy

Imp system/manager file = tank log = tank fromuser = (seapark, amy)

Touser = (seapark1, amy1)

5. Import a table

Imp system/manager file = tank log = tank fromuser = seapark TABLES = (a, B)

6. Import from multiple files

Imp system/manager file = (paycheck_1, paycheck_2, paycheck_3, paycheck_4)

Log = paycheck, filesize = 1G full = y

7. Use the parameter file

Imp system/manager parfile = bible_tables.par

Bible_tables.par parameter file:

# Import the sample tables used for the Oracle8i Database Administrator's

Bible. fromuser = seapark touser = seapark_copy file = seapark log = seapark_import

8. incremental Import

Imp system./manager inctype = rectore full = y file =

Oracle imp/exp

C: Documents and Settingsadministrator> exp help = y

Export: Release 9.2.0.1.0-Production on Wednesday July 28 17:04:43 2004

Copyright (c) 1982,200 2, Oracle Corporation. All rights reserved.

========================================================== ===

By entering the EXP command and user name/password, you can
Command followed by user name/password:

Routine: exp scott/TIGER

Alternatively, you can control "Export" by entering the EXP command with various parameters"
According to different parameters. To specify parameters, you can use the Keyword:

Format: exp keyword = value or KEYWORD = (value1, value2,..., valueN)
Routine: exp scott/tiger grants = y tables = (EMP, DEPT, MGR)
Or TABLES = (T1: P1, T1: P2). If T1 is a partitioned table

USERID must be the first parameter in the command line.

Keyword description (default) keyword description (default)
--------------------------------------------------------------------------
USERID username/password FULL export the entire file (N)
BUFFER data BUFFER size OWNER User Name List
FILE output FILE (EXPDAT. DMP) TABLES Table Name List
Length of the IO record that COMPRESS imports to a partition (Y) RECORDLENGTH
GRANTS export permission (Y) INCTYPE incremental export type
INDEXES export index (Y) RECORD trace incremental Export (Y)
DIRECT path (N) TRIGGERS export trigger (Y)
The LOG file STATISTICS analysis object (ESTIMATE) output by the LOG Screen)
ROWS export data row (Y) PARFILE parameter file name
CONSISTENT cross tabulation consistency (N) CONSTRAINTS exported by CONSTRAINTS (Y)

OBJECT_CONSISTENT only sets transaction processing to read during object Export (N)
Progress of each row of FEEDBACK (0)
FILESIZE: maximum size of each dump.
FLASHBACK_SCN is used to set the session snapshot back to the previous state SCN
FLASHBACK_TIME is used to obtain the SCN time closest to the specified time.
QUERY: select clause used to export a subset of a table
When the RESUMABLE encounters a space-related error, it suspends (N)
RESUMABLE_NAME is a text string used to identify a recoverable statement.
The waiting time of RESUMABLE_TIMEOUT RESUMABLE.
TTS_FULL_CHECK performs a complete or partial correlation check on TTS.
Table space list of TABLESPACES to Be Exported
TRANSPORT_TABLESPACE export the table space metadata that can be transferred (N)
TEMPLATE: name of the TEMPLATE to be exported in iAS mode.

The export is successfully terminated without warning.
========================================================== ============

C: Documents and Settingsadministrator> imp help = y

Import: Release 9.2.0.1.0-Production on Wednesday July 28 17:06:54 2004

Copyright (c) 1982,200 2, Oracle Corporation. All rights reserved.

You can enter the IMP command and your username/password.
Command followed by user name/password:

Routine: imp scott/TIGER

Alternatively, you can control "import" by entering the IMP command and various parameters"
According to different parameters. To specify parameters, you can use the Keyword:

Format: imp keyword = value or KEYWORD = (value1, value2,..., vlaueN)
Routine: imp scott/tiger ignore = y tables = (EMP, DEPT) FULL = N
Or TABLES = (T1: P1, T1: P2). If T1 is a partitioned table

USERID must be the first parameter in the command line.

Keyword description (default) keyword description (default)
--------------------------------------------------------------------------
USERID username/password FULL

For more information about Oracle, see Oracle topics page http://www.bkjia.com/topicnews.aspx? Tid = 12