Oracle imp exp Command Parameters

Oracle imp Command Parameters

Blog type: 
• Oracle Import and Export

Oraclecc ++ C #

Ii. IMP
C: \> imp help = y

You can enter the IMP command and your username/password.
Command with your username/password:

Instance: IMP Scott/Tiger

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

Format: IMP keyword = value or keyword = (value1, value2,..., vlauen)
Instance: 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.

 

Keywords	Description	Default
Userid	Username/password
Full	Import the entire file	(N)
Buffer	Data buffer size
Fromuser	User name list for all users
File	Input File (expdat. dmp)
Touser	User Name List
Show	Only list 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	Submit array insertion	(N)
Rows	Import data rows	(Y)
Parfile	Parameter file name
Log	Log files output on the screen
Constraints	Import restrictions	(Y)
Destroy	Overwrite the tablespace Data File	(N)
Indexfile	Write table/index information to the specified file
Skip_unusable_indexes	Skip maintenance of unavailable Indexes	(N)
Analyze	Execute the analyze statement in the dump file
Feedback	Displays the progress of each X rows (0)
Toid_novalidate	Skips verification of the specified type ID.
Filesize	Maximum size of each dump file
Recalculate_statistics	Recalculate the statistical value	(N)
The following keywords are only used for table spaces that can be transferred.
Transport_tablespace	Import writable tablespace metadata	(N)
Tablespaces	Tablespace to be transmitted to the database
Datafiles	Data files to be transmitted to the database
Tts_owners	Users with the ability to transmit table space centralized data

Shared to: how to change the database archiving mode | Oracle working mechanism Oracle exp Command Parameters

Blog type: 
• Oracle Import and Export

Oraclecc ++ C #

1. Exp

C: \> exp help = y

By entering the exp command and user name/password, you can
Command after user/password:

Example: EXP Scott/Tiger

Alternatively, you can control the running mode of "Export" by entering the exp command with various parameters.
To specify parameters, you can use the Keyword:

Format: EXP keyword = value or keyword = (value1, value2,..., valuen)
Instance: 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.

 

Keywords	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	Import a range	(Y)
Recordlength	Length of Io record
Grants	Export Permission	(Y)
Inctype	Incremental export type
Indexes	Export Index	(Y)
Record	Track incremental Export	(Y)
Rows	Export data rows	(Y)
Parfile	Parameter file name
Constraints	Export restrictions	(Y)
Consistent	Cross tabulation consistency
Log	Log files output on the screen
Statistics	Analysis object (estimate)
Direct	Direct path	(N)
Triggers	Export trigger	(Y)
Feedback	Displays the progress of each X rows (0)
Filesize	Maximum size of each dump file
Query	Select the clause of the exported table subset
The following keywords are only used for table spaces that can be transferred.
Transport_tablespace	Export writable tablespace metadata	(N)
Tablespaces	List of tablespaces to be transmitted

Shared to: Common Oracle imp commands | generate a codesmith template for an object class