Oracle Data Import and Export Learning

I. Oracle data export: (1. Completely export the data in the linuxidc database. The username and password of the database are linuxidc and exported to the local E: data.

1. Oracle data export: (1. Completely export the data in the linuxidc database, and export the username and password of the database to the local E: \ data.

1. Oracle data export:

(1) completely export the data of the linuxidc database, the username of the database linuxidc, And the password linuxidc to the local E: \ data. dmp.

Exp linuxidc/linuxidc @ linuxidc file = E: \ data. dmp full = y

(2) export the tables of linuxidc users and sys users in the database

Exp linuxidc/linuxidc @ linuxidc file = E: \ data. dmp owner = (linuxidc, sys)

(3) Export tables table1 and table2 in the database

Exp linuxidc/linuxidc @ linuxidc file = E: \ data. dmp tables = (table1, table2)

(4) export the data with the field "area" in table 1 in the database as "Nanchang"

Exp system/manager @ TEST file = E: \ data. dmp tables = (table1) query = \ "where area = 'nanchang '\"

The preceding commands can cope with common export operations. If you want to compress the exported data file dmp, you can use zip or WinRAR, you can also append the command parameter compress = y after the preceding command to compress.

Ii. Oracle data import:

(1) import the data in E: \ data. dmp to the linuxidc database.

Imp linuxidc/linuxidc @ linuxidc file = E: \ data. dmp

Some warnings or problems may occur during the import process. For example, if a table already exists, an error is reported, so the table is not imported. At this time, the import operation will stop, but we want to continue the subsequent import, you can add ignore = y after a warning, problem:

Imp linuxidc/linuxidc @ linuxidc full = y file = E: \ data. dmp ignore = y

For more information about Oracle, see the Oracle topic page? Tid = 12