Oracle Database Import Export statement

Oracle's EXP/IMP command is used to implement export/import operations to the database; the EXP command is used to bring data from the remote database server to the local, generating a. dmp file; The IMP command is used to import local database. dmp files from local to the remote Oracle database

1 fully export the database test. User name System/manager Export to D:daochu.dmp code as follows:

Exp system/[email protected] file=d:daochu.dmp full=y

2. Export the table of the system user and SYS user in the database with the following code:

Exp system/[email protected] file=d:daochu.dmp owner= (System,sys)

3. table1 The table in the database table2 the export code as follows:

Exp system/[email protected] file:= d:daochu.dmp tables= (table1,table2)

4. table1 The fields in the table in the database filed1 the data exported with "00" as follows;

Exp system/[email protected] file:=d:daochu.dmp tables= (table1) query= "where filed1 like ' 0% '"

5. Import the data from the D:DAOCHU.DMP into the test database in the following code

Imp system/[email protected] File:=d:doachu.dmp (This will definitely be an error, because the table already exists in the database, the table can not be imported)

So I'm going to add ignore=y to the back.

Imp system/[email protected] File:=d:daochu.dmp ignore=y It's OK.

6. Import the table Table1 in D:DAOCHU.DMP into the test database

Imp system/[email protected] file:=d:daochu.dmp tables= (table1);

Oracle Database Import Export statement