How can we help you today?
Import script is taking too long in Oracle
1 Comment
Joel Jonsson
said
about 1 year ago
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 https://confluence.dbvis.com/display/UG232/@import+-+Importing+data
Regards,
Joel
Maruen Mehana
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.
@IMPORT ON;
@RUN "/home/maruen/Dropbox/15-APPS/SQL/CM_OWN-PROD-05-09-2023.SQL"
@IMPORT OFF;
Please give me some help regarding that.
Thanks.