How Oracle databases are exported and re-import

Oracle database Export and re-import one, export database?

1 2 3 4 5 6

1, the database TEST completely exported, user name Scott password Tiger, exported to d:testdb.dmp: [plain] exp scott/tiger@test file=d:testdb.dmp full=y 2, To export the table EMP in the database: [plain] exp scott/tiger@test file=d:testdb.dmp tables= (EMP)

Second, import the database

1 2 3 4 5 6

1. Import a full database [plain] imp scott/tiger@test file=d:testdb.dmp full=y ignore=y 2, import a table emp [plain] imp scott/tiger@test file=d : Testdb.dmp tables= (EMP)

Report:

1 2 3 4 5 6 7 8 9

1. Cascade Delete user scott: [SQL] drop user Scott Cascade;  2. Create user Scott, password tiger: [SQL] Create user Scott identified by Tiger; 3. Give Scott DBA Authority: [SQL] Grant DBA to Scott;