Detailed "Go" in Oracle with exp/imp command parameters

EXP/IMP Command parameters in Oracle

"Export with exp data":
1 full export of database test, user Name System Password Manager exported to D:\daochu.dmp
Exp system/[email protected] rows=y indexes=y compress=n buffer=65536 feedback=100000F Ull=y file=d:\daochu.dmp log=d:\daochulog.txt owner= (Ecc_biz,ecc_customer)

Key words	Description	Default
Userid	User name/password
Full	Export the entire file	N
BUFFER	Size of the data buffer
OWNER	Export the list of named owner user names
FILE	Output file	(Expdat. DMP)
TABLES	Export A list of list Names
COMPRESS	Whether to compress exported files	(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 Restrictions	(Y)
Consistent	Cross-table consistency
LOG	Log file for screen output
STATISTICS	Analytical Objects (ESTIMATE)
DIRECT	Direct path	N
TRIGGERS	Export triggers	(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
Transport_tablespace	Export the transportable tablespace metadata	N
Tablespaces	Export A list of defined table spaces

2 Exporting the system user in the database to the SYS user's table
Exp system/[email protected] file=d:\daochu.dmp owner= (System,sys)

3 Exporting Tables Table1, table2 in the database
Exp system/[email protected] file=d:\daochu.dmp tables= (table1,table2)

4 Export the field filed1 in the table table1 in the database with the data that begins with the 00″
Exp system/[email protected] file=d:\daochu.dmp tables= (table1) query=\ "where Filed1like '00%& Apos;\ "

The above is a common export, for compression I do not care, with WinZip to the DMP file can be very good compression. But add compress=y to the above command.

"Import with IMP data":

1 Import the data from the D:\DAOCHU.DMP into the test database.
Imp system/[email protected] ignore=y full=y file=d:\daochu.dmp log=d:\daoru.txt

Key words	Description	Default
Userid	User name/password
Full	Import the entire file	N
BUFFER	Data buffer size
Fromuser	List of all user names
FILE	Input file	(Expdat. DMP)
Touser	List of user names
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 Insert	N
ROWS	Import data rows	(Y)
Parfile	Parameter file name
LOG	Log file for screen output
CONSTRAINTS	Import restrictions	(Y)
DESTROY	Overwrite table space data files	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
Toid_novalidate	Skipping validation of a specified type ID
FILESIZE	Maximum size of each dump file
STATISTICS	Always import precomputed statistics
Resumable	Hangs 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	Import generic metadata for Streams	(Y)
Streams_instanitation	Importing instantiated metadata for Streams	N
Transport_tablespace	Import Transportable Tablespace metadata
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

1. Get Help

Imp help=y

2. Import a full database

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

3. Import all of the tables, indexes, and other objects that a specified user or group belongs to

Imp System/manager file=seapark Log=seapark Fromuser=seapark

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

4. Import data belonging to one user into another user

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. Importing from multiple Files

Imp System/manager file= (paycheck_1,paycheck_2,paycheck_3,paycheck_4) log=paycheck,filesize=1g full=y

7. Using 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 (canceled in 9i)

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

Recommended reference: Http://www.cnblogs.com/songdavid/articles/2435439.html

Detailed "Go" in Oracle with exp/imp command parameters