Use the Oracle database exp/IMP command

I. Database Table trpw_sample100hz export and import methods

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,200 5, 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

The zhs16gbk and al16utf16 nchar character sets have been exported.

 

To export the specified table, use the regular path...

.. Export table trpw_sample100hz Export 2 rows

The export is successfully terminated without a warning.

 

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 mainly prevents the table from already exists in the data. An error is reported when you import the data.

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

 

Copyright (c) 1982,200 5, 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 File Created by export: v10.02.01 in the normal path

The zhs16gbk Character Set and al16utf16 nchar character set have been imported.

. Importing SA object to sa

. Importing SA object to sa

.. Importing two rows into the table "trpw_sample100hz "...

Import terminated successfully. No warning is displayed.

 

C: \ windows \ system32>

 

Ii. Database SA User table export and import methods

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,200 5, 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

The zhs16gbk and al16utf16 nchar character sets have been exported.

 

Will export the specified user...

. Exporting objects and operations in the pre-schema Process

. Exporting the external function library name of user SA

. Export public type Synonyms

. Exporting the special type Synonym

. Exporting the SA object type definition.

Sa object to be exported...

. Exporting database link...

. Exporting sequence number

. Exporting cluster Definition

. To export the SA table through the regular path...

.. Export table trpw_sample100hz Export 2 rows

. Exporting Synonym

. Exporting view...

. Exporting the Stored Procedure

. Exporting Operator

. The reference integrity constraints are being exported.

. Exporting trigger...

. Exporting index type...

. Exporting bitmap, functional index, and scalable Index

. Exporting table activity later

Exporting the Materialized View

Exporting snapshot logs

. Exporting Job Queue...

. Exporting refresh group and sub-group

. Exporting dimension...

. Exporting objects and operations in the Post-schema Process

. Exporting statistics

The export is successfully terminated without a warning.

 

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,200 5, 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 File Created by export: v10.02.01 in the normal path

The zhs16gbk Character Set and al16utf16 nchar character set have been imported.

. Importing SA object to sa

. Importing SA object to sa

.. Importing two rows into the table "trpw_sample100hz "...

Import terminated successfully. No warning is displayed.

 

C: \ windows \ system32>

Iii. Description

If you only want to export individual tables, you can use the first method. If you want to export the entire user table, you can use the second method. A rejection error may occur when you use the IMP command to import data: ORA-00001: violates a unique constraint that you can ignore to maintain data consistency in the import table, the simplest way is to delete the full data of the table. In many cases, you must first completely delete the table and then import the backup data table file.