Text importer slow down on large files

[cct]

The text importer is great with small files, but absolutely useless with very large ones.

By mistake I earlier loaded a text file with 51185 small records, which took 1087 seconds - not very good. For larger files I now will only use SQL Developer, as that has the speed.

Can this possibly be addressed?

 

[cct]

Also on the third load it just hung...

 

[Marco Kalter]

We'll check it out. Can you let me know your PL/SQL Developer version?

 

[cct]

Version 12.0.3.1821 (32 bit)

But the lack of speed has been noticed frequently with past versions, as has locking the application.

Thanks

Chris

 

[Marco Kalter]

We're looking into this for 12.0.4.

 

[ScottNightlinger]

Currently licensed version 10.0.5.1710 hangs and locks on a 2.75 GB csv text file with 34 million records after loading 750,000 records, with commit set to 100,000 records. Trial version 12.0.4.1826 (32 bit) slows to 5000 records per minute with commit set every 2000 records, after having loaded 750,000 records. At this rate, it will require 4.6 days to load the 34 million records, assuming it doesn't slow down further. PL/SQL Developer has been my preferred editor for ten years now. Am experiencing work stoppage and currently requesting the Help Desk install Oracle's SQL Developer (64 bit).

 

[ScottNightlinger]

My issue is now solved. There was a duplicate record about 200 records into the file that violated the primary key constraint. Oracle SQL Developer threw an error, I dropped the primary key, and then the data loaded with no further issues in both editor environments. Oracle SQL Developer threw the primary key duplicate record error, Allround Automations PL/SQL Developer did not.