1 person found this helpful
Datapump uses direct path method of moving data. In this method, the SQL layer of the database is bypassed and rows are moved to and from the dump file with only minimal interpretation. Data Pump automatically uses the direct path method for loading and unloading data when the structure of a table allows it.
There are no command like COMMIT=Y as it is not required in direct path impdp.
Thanks & Regards
Thanks rakesh, that is a very bright explanation
By the way why is our EXPDP when run, is hogging resources? I mean the tables being backed-up seems frozen such that the insert are held up? Is there a parameter to prevent this behavior?