How to export and re-import oracle databases

Oracle Database Export and re-import 1. Export Database? 1234561 completely export the database TEST, username scott password tiger, and export to D: testDB. in dmp: [plain] expscotttiger @ TESTfiled: testDB. dmpfully2. Export the table emp in the database: [plain] expscotttiger @ TESTf

Oracle Database Export and re-import 1. Export Database? 1 2 3 4 5 6 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 f

Oracle Database Export and re-import

1. Export the database

?

1

2

3

4

5

6

1. Completely export the database TEST, username scott password tiger, and export it to D: testDB. 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

2

3

4

5

6

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

2

3

4

5

6

7

8

9

1. Cascade delete user scott:

[SQL]

Drop user scott cascade;

2. Create user scott and password tiger:

[SQL]

Create user scott identified by tiger;

3. Grant DBA permissions to scott: