Oracle Database Export and re-import

Oracle Database Export and re-import 1. Export Database

1. Completely export the database TEST, username scott password tiger, and export it to D: \ testDB. in dmp: [plain] exp scott/tiger @ TEST file = d: \ testDB. dmp full = y 2. Export the table emp in the database: [plain] exp scott/tiger @ TEST file = d: \ testDB. dmp tables = (emp)

 

Ii. Import Database

1. Import a complete 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)

 

Appendix:

1. cascade delete user scott: [SQL] drop user scott cascade; 2. create user scott, password tiger: [SQL] create user scott identified by tiger; 3. grant DBA permissions to scott: [SQL] grant dba to scott;