Import Schema Using Data Pump
Published by : Obay Salah , November 19, 2024
Let's assume we have a new user named NEW, and we want to import the user VBS object data from the export file for user NEW.
impdp NEW/NEW dumpfile=VBSMAIN.dmp directory=direct SCHEMAS=VBS JOB_NAME=JB1
We have imported the VBS user object data from the export file to the NEW user.
The JOB can also be controlled by the START_JOB AND STATUS AND STOP_JOB commands.
Comments
no comment yet!