Start a new topic

Import script is taking too long in Oracle

Hello, I was able to export an Oracle dump file with DbVisualizer in only 10 minutes more or less.

The size of it is around 2 Gigas.

But when importing it, it's taking hours and even days.

Am I doing something wrong? I think if it took only 10 minutes to generate it, it shouldn't take that long to import it.

I'm running with the following way.


@RUN "/home/maruen/Dropbox/15-APPS/SQL/CM_OWN-PROD-05-09-2023.SQL"


Please give me some help regarding that.


1 Comment

You can try exporting in CSV and then use import with Batch Import enabled in DbVisualizer to import the data. This might be quicker.

For more details on the import command see


Login or Signup to post a comment