Oracle Database EXP/IMP Command use

table trpw_sample100hz Export and Import methods in the database

1), Export

C:\windows\system32>exp Sa/liuxuezong@rtsos file=d:\test.dmp tables= (trpw_sample100hz

)

Export:release 10.2.0.1.0-production on Friday February 17 08:59:49 2012

Copyright (c) 1982, +, Oracle. All rights reserved.

Connect to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-production

With the partitioning, OLAP and Data Mining options

Exported ZHS16GBK character set and Al16utf16 NCHAR character set

About to export the specified table through the general path ...

. . Exporting table trpw_sample100hz 2 rows exported

The export was successfully terminated and no warning occurred.

C:\windows\system32>

2), import

C:\windows\system32>imp Sa/liuxuezong@rtsos file=d:\test.dmp tables= (trpw_sample100hz

) ignore=y

The Ignore=y function primarily prevents the table from being present in the data and prompts for an error when importing data.

Import:release 10.2.0.1.0-production on Friday February 17 08:57:18 2012

Copyright (c) 1982, +, Oracle. All rights reserved.

Connect to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-production

With the partitioning, OLAP and Data Mining options

Export files created by export:v10.02.01 through a regular path

Import in the ZHS16GBK character set and Al16utf16 NCHAR character set has been completed

. Importing an SA object into an SA

. Importing an SA object into an SA

. . Importing table ' trpw_sample100hz ' imported 2 rows

The import was successfully terminated and no warning occurred.

C:\windows\system32>

ii. Table Export and import methods for SA users in the database

1), Export

C:\windows\system32>exp Sa/liuxuezong@rtsos file=d:\rtsos.dmp owner= (SA)

Export:release 10.2.0.1.0-production on Friday February 17 09:22:09 2012

Copyright (c) 1982, +, Oracle. All rights reserved.

Connect to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-production

With the partitioning, OLAP and Data Mining options

Exported ZHS16GBK character set and Al16utf16 NCHAR character set

The specified user is about to be exported ...

. Exporting Pre-schema process objects and actions

. Exporting the name of the external function library for the user SA

. Export public type synonyms

. Exporting private type synonyms

. Exporting the user SA's object type definition

The object that is about to export the SA ...

. Exporting database Links

. Exporting ordinal

. Exporting cluster definitions

. The table that is about to export the SA passes the general path ...

. . Exporting table trpw_sample100hz 2 rows exported

. Exporting synonyms

. Exporting views

. Exporting stored Procedures

. Exporting operators

. Exporting referential integrity constraints

. Exporting triggers

. Exporting index types

. Exporting bitmaps, functional indexes, and extensible indexes

. Exporting late table activity

. Exporting materialized views

. Exporting snapshot logs

. Exporting job queues

. Exporting refresh groups and subgroups

. Exporting dimension

. Exporting Post-Schema process objects and actions

. Exporting statistics

The export was successfully terminated and no warning occurred.

C:\windows\system32>

2), import

C:\windows\system32>imp Sa/liuxuezong@rtsos file=d:\rtsos.dmp full=y ignore=y

Import:release 10.2.0.1.0-production on Friday February 17 09:49:12 2012

Copyright (c) 1982, +, Oracle. All rights reserved.

Connect to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-production

With the partitioning, OLAP and Data Mining options

Export files created by export:v10.02.01 through a regular path

Import in the ZHS16GBK character set and Al16utf16 NCHAR character set has been completed

. Importing an SA object into an SA

. Importing an SA object into an SA

. . Importing table ' trpw_sample100hz ' imported 2 rows

The import was successfully terminated and no warning occurred.

C:\windows\system32>

Iii. Description

If you just want to export an individual table, you can use the first method, and if you want to export the entire user table, you can use the second method. When you import data by using the IMP command, there may be a rejection error: ORA-00001: You can ignore the unique constraint, and to keep the data consistency of the imported table, the easiest way to do this is to delete the table full data, and in many cases, first delete the table completely before you import the backed-up datasheet file.