Oracle backup and recovery exp/IMP Command Parameters

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

Ii. 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)