EXP/IMP Command Parameters

Source: Internet
Author: User
EXP/IMP Command Parameters

1. Exp:

1. Complete:
Exp system/Manager Buffer = 64000 file = C:/full. dmp full = y
To perform full export, you must have special permissions.

2. User Mode:
Exp Sonic/sonic buffer = 64000 file = C:/sonic. dmp owner = sonic
In this way, all the sonic objects are output to the file.

 

3. Table mode:
Exp Sonic/sonic buffer = 64000 file = C:/sonic. dmp owner = sonic tables = (sonic)
In this way, the sonic table is exported.

Exp parameter:
Keyword description (default)
----------------------------------------------
Userid username/password
Full export the entire file (N)
Buffer data buffer size
Owner owner username list
File output file (expdat. dmp)
Tables Table Name List
Compress imports a range (y)
Recordlength Io record length
Grants export permission (y)
Inctype incremental export type
Indexes export index (y)
Incremental export of record tracking (y)
Rows export data rows (y)
Parfile parameter file name
Constraints export limit (y)
Consistent cross tabulation consistency
Log File output by log Screen
Statistics Analysis object (estimate)
Direct direct path (N)
Triggers export trigger (y)
Feedback displays the progress of each X row (0)
Filesize maximum size of each dump file
Query the clause of the selected export table subset

2. IMP:

Three modes are available (full, user, and table)

1. Complete:
IMP system/Manager Buffer = 64000 file = C:/full. dmp full = y

2. User Mode:
IMP Sonic/sonic buffer = 64000 file = C:/sonic. dmp fromuser = sonic touser = sonic
In this way, all the sonic objects are imported into the file. You must specify the fromuser and touser parameters to import data.

3. Table mode:
Exp Sonic/sonic buffer = 64000 file = C:/sonic. dmp owner = sonic tables = (sonic)
In this way, the sonic table is imported.

IMP parameters:
Keyword description (default)
----------------------------------------------
Userid username/password
Full import of the entire file (N)
Buffer data buffer size
Fromuser User Name List
File input file (expdat. dmp)
Touser User Name List
Show only lists file content (N)
Tables Table Name List
Ignore ignore creation error (N)
Recordlength Io record length
Grants import permission (y)
Inctype incremental Import Type
Indexes import index (y)
Commit submits array insert (N)
Rows import data rows (y)
Parfile parameter file name
Log File output by log Screen
Constraints import restrictions (y)
Destroy overwrite the tablespace data file (N)
Indexfile writes table/index information to the specified file
Skip_unusable_indexes skips maintenance of unavailable indexes (N)
Analyze executes the analyze Statement (y) in the dump file)
Feedback displays the progress of each X row (0)
Toid_novalidate skips the verification of the specified type ID
Filesize maximum size of each dump file
Recalculate_statistics recalculates the statistical value (N)

1. Exp:

1. Complete:
Exp system/Manager Buffer = 64000 file = C:/full. dmp full = y
To perform full export, you must have special permissions.

2. User Mode:
Exp Sonic/sonic buffer = 64000 file = C:/sonic. dmp owner = sonic
In this way, all the sonic objects are output to the file.

 

3. Table mode:
Exp Sonic/sonic buffer = 64000 file = C:/sonic. dmp owner = sonic tables = (sonic)
In this way, the sonic table is exported.

Exp parameter:
Keyword description (default)
----------------------------------------------
Userid username/password
Full export the entire file (N)
Buffer data buffer size
Owner owner username list
File output file (expdat. dmp)
Tables Table Name List
Compress imports a range (y)
Recordlength Io record length
Grants export permission (y)
Inctype incremental export type
Indexes export index (y)
Incremental export of record tracking (y)
Rows export data rows (y)
Parfile parameter file name
Constraints export limit (y)
Consistent cross tabulation consistency
Log File output by log Screen
Statistics Analysis object (estimate)
Direct direct path (N)
Triggers export trigger (y)
Feedback displays the progress of each X row (0)
Filesize maximum size of each dump file
Query the clause of the selected export table subset

2. IMP:

Three modes are available (full, user, and table)

1. Complete:
IMP system/Manager Buffer = 64000 file = C:/full. dmp full = y

2. User Mode:
IMP Sonic/sonic buffer = 64000 file = C:/sonic. dmp fromuser = sonic touser = sonic
In this way, all the sonic objects are imported into the file. You must specify the fromuser and touser parameters to import data.

3. Table mode:
Exp Sonic/sonic buffer = 64000 file = C:/sonic. dmp owner = sonic tables = (sonic)
In this way, the sonic table is imported.

IMP parameters:
Keyword description (default)
----------------------------------------------
Userid username/password
Full import of the entire file (N)
Buffer data buffer size
Fromuser User Name List
File input file (expdat. dmp)
Touser User Name List
Show only lists file content (N)
Tables Table Name List
Ignore ignore creation error (N)
Recordlength Io record length
Grants import permission (y)
Inctype incremental Import Type
Indexes import index (y)
Commit submits array insert (N)
Rows import data rows (y)
Parfile parameter file name
Log File output by log Screen
Constraints import restrictions (y)
Destroy overwrite the tablespace data file (N)
Indexfile writes table/index information to the specified file
Skip_unusable_indexes skips maintenance of unavailable indexes (N)
Analyze executes the analyze Statement (y) in the dump file)
Feedback displays the progress of each X row (0)
Toid_novalidate skips the verification of the specified type ID
Filesize maximum size of each dump file
Recalculate_statistics recalculates the statistical value (N)

 

Bytes ------------------------------------------------------------------------------------

 

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 =

 

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.