Create an SQL script

Connects to the Scott schema (as SYSDBA; be sure that admin privileges have been assigned)

Exports the tables (DEPT, EMP, BONUS, SALGRADE) from the Scott schema

Connects to user40 schema (created in a previous project)

Imports all the tables (DEPT, EMP, BONUS, SALGRADE) from the Scott schema

Notes:

The Data Pump Utility can be used ro perform Logical Backup & and Recovery operations.

Review SQL Plus for details of issuing operating system commands from an SQL script.

Verify that the SCOTT account contains all the required tables. If not, run the "cretabs.sql" script (located in the Module section)

Create a a "Directory" object DATA_PUMP_DIR that points to "C:\Temp"

Create the "user40" account (if non-existent)

Grant the DATABASE_IMP_FULL_DATABASE to the "user40" account

Run the "expdb" program in "Table Export" mode with the "DIRECTORY" parameter

Run the "impdb" program in "Table Import" mode with the "DIRECTORY" parameter

Documentation for the "Oracle Data Pump Utility"