Oracle Database Import and Export instances

Note: test is the database name, and test. DMP is the exported Oracle database backup.

 

Import:
1. c: \ indicates that the source backup file is in the C root directory.
IMP system/manager @ test file = c: \ test. dmp fromuser = System

If some tables already exist, an error may be reported. You can use:
IMP system/manager @ test file = c: \ test. dmp fromuser = system ignore = y

 

2. Import table 1 in D: \ daochu. dmp

IMP system/manager @ test file = D: \ daochu. dmp tables = (Table1)

Export:
1. Back up the database fireweb to disk D, named test. DMP, full = Y for full backup

Exp system/manager @ test file = D: \ test. dmp full = y