Shulou(Shulou.com)05/31 Report--

This article mainly introduces how to use exp and imp in Oracle. It is very detailed and has a certain reference value. Friends who are interested must finish it!

Oracle database import and export method:

Data export:

1. Export database TEST completely, username system password manager to D:\ daochu.dmp

Exp system/manager@TEST file=d:\ daochu.dmp full=y

two。 Export tables for system and sys users in the database

Exp system/manager@TEST file=d:\ daochu.dmp owner=system,sys

3. Export the tables inner _ notify and notify_staff_relat in the database

Exp aichannel/aichannel@TESTDB2 file= d:\ data\ newsmgnt.dmp tables= (inner_notify,notify_staff_relat)

4. Export the field filed1 in the table table1 in the database with data starting with "00"

Exp system/manager@TEST file=d:\ daochu.dmp tables= (table1) query=\ "where filed1 like'00%'\"

The above are commonly used exports, for compression, both using winzip to dmp files can be very good compression.

You can also add compress=y to the above command.

Import of data:

1. Import the data from D:\ daochu.dmp into the TEST database.

Imp system/manager@TEST file=d:\ daochu.dmp

Imp aichannel/aichannel@HUST full=y file= d:\ data\ newsmgnt.dmp ignore=y

There may be a problem above, because some table already exists, and then it reports an error and does not import the table.

Just add ignore=y at the end.

two。 Import the table table1 from d:\ daochu.dmp

Imp system/manager@TEST file=d:\ daochu.dmp tables= (table1)

2.plsql:

Data export:

TOOLS-Export user objects (user object)

TOOLS-Export tables (Table)

Import of data:

TOOLS-Import tables

Oracle Import (table) SQL Inserts (user object)

You can also copy the statements of the user object and paste them into Command Window. The advantage is that you can see the execution process.

EXP-00091: Exporting questionable statistics.

SQL > select * from v$nls_parameters where parameter='NLS_CHARACTERSET'

PARAMETER VALUE

NLS_CHARACTERSET ZHS16GBK

SQL > host

Lpding- > export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

Lpding- > exp scott/scott file=/oracle/exp/scott_emp.dmp log scott_emp.log tables=emp

The above is all the contents of the article "how to use exp and imp in Oracle". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.