Oracle Database Export and re-import

Yan Bin (write to me)
Original blog (http://blog.csdn.net/binbinxyz), reprint please indicate the source!
1. Export the database

1. Completely export the database test, username Scott password tiger, and export it to D: \ testdb. dmp:

Exp Scott/tiger @ test file = D: \ testdb. dmp

2. Export the table EMP in the database:

Exp Scott/tiger @ test file = D: \ testdb. dmp tables = (EMP)

Ii. Import Database

1. Import a complete database

IMP Scott/tiger @ test file = D: \ testdb. dmp full = y ignore = y

2. Import a table EMP

IMP Scott/tiger @ test file = D: \ testdb. dmp tables = (EMP)

The preceding Import and Export commands can be executed in the CMD window.

Appendix:
1. Cascade delete user SCOTT:

Drop user Scott cascade;

2. Create user Scott and password Tiger:

Create user Scott identified by tiger;

3. Grant DBA permissions to Scott:

Grant DBA to Scott;