Import Database Using Data Pump
Published by : Obay Salah , November 19, 2024
The database can be imported by Data Pump from the export file.
impdp SYSTEM/SYS dumpfile=FULL1.dmp directory=direct FULL=Y
This is how we imported the database.
You can also control the JOB as we did when exporting the database using the Data Pump.
Features and advantages of the Data Pump:
One of the most important features of the Data Pump compared to the normal method is speed, as this method is faster than
the normal method by about 01 to 51 times. A job is also created to perform export or import, which facilitates the process of controlling the export process
This is done through commands that can be used to control the Jobs so that the Job can be stopped if there is a group of Processes working and run at the appropriate time.
You can inquire using:
DBA_DATAPUMP_JOBS
DBA_DATABPUMP_SESSIONS
Comments
no comment yet!