Oracle Database Import and Export

In the Command Prompt window (cmd.exe), enter

1. Step by step

1. Step-by-Step Export

C: \ Documents ents and Settings \ Administrator> exp

Username: userid (the user created in the database under security)

Password: Password

Buffer size for input array extraction: 4096> (Press ENTER)

Export File: expdat. DMP> C: \ A. dmp (enter the export file storage address and name here)

<1> E, <2> U, <3> T> 2 (select the export type here, and select export by user)

Export Permission> (Press ENTER)

Export table data> (Press ENTER)

Compression Area> (Press ENTER)

User> userid to Be Exported

User to be exported> (Press ENTER)

End #

2. Import Distribution

Step 1: start inputting imp

Note:

Only list the content of the imported file. Select No.

Select Yes to import the entire exported file.

Ii. Direct Import and Export

1. Export directly

(1) completely export the database test, and export the userid and password to D: \ daochu. dmp.
Exp
USERID/password @ Test
File = D: \ daochu. dmp full = y
(2) Export the tables of userid1 users and userid2 users in the database
Exp
Userid1/password @ Test
File = D: \ daochu. dmp owner = (userid1, userid2)
(3) Export tables Table1 and Table2 in the database
Exp
USERID/password @ Test
File = D: \ daochu. dmp tables = (Table1, table2)
(4) export the data with the field filed1 in table 1 in the database starting with "00"
Exp
USERID/password @ Test
File = D: \ daochu. dmp tables = (Table1) query = \ "where filed1 like '000000 '\"

2. Direct import

(1) import data from D: \ daochu. dmp to the test database.
IMP
USERID/password @ Test
File = D: \ daochu. dmp ignore = y
(2) Import table 1 in D: \ daochu. dmp
IMP
USERID/password @ Test
File = D: \ daochu. dmp tables = (Table1)