I am using Oracle DBMS_DATAPUMP API to import a dumpfile containing some table data.

Is it possible to stop the job and issue COMMIT; in the same session to maybe cleanup UNDO tablespace and then resume the import?


  • No such thing in Data Pump. How do you import the data? Data Pump automatically chooses direct path import when it is available, and that should significantly reduce redo/undo generation, but there are some factors that can prevent performing a direct path load. For example if you try to import data to an existing table, enabled FK constraints and triggers on the table prevent a direct path load. – Balazs Papp Mar 24 '17 at 13:33
  • @BalazsPapp Thanks for your reply !! I am using DATAPUMP API for the import of data. Yes, I am frequently facing problem while importing huge datasets (using command-line impdp) which is filling-up around 12GB UNDO tbs for which I am eager to know if we can COMMIT; in between the process. – Bibhuti Bhusan Padhi Mar 24 '17 at 13:51
  • There is no commit, but you could try to import smaller data sets(with QUERY clause) multiple times maybe? Also, are you importing to existing tables with enabled constraints and indexes? If you do then direct path access won't be used and you'll have undo generated. – mutap Mar 24 '17 at 20:50
  • @mutap Thanks for your answer. Yes I imported data into table with constraints and indexes. Will it be safe if I disable constraints during import ? And in such scenarios importing in smaller datasets have worked maybe I can automate that in a script. – Bibhuti Bhusan Padhi Mar 25 '17 at 4:04

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.