Rob van Rijen
Member²
Hi,
I know I can use sqlldr but...
When you want to upload records to a database you can copy and paste data directly in a table using Edit Data. I use this method as a fast way to get data from Excel to Oracle.
The amount of resources used by this functionality is extreme! Uploading a dataset of 40.000 records with 10 fields caused my PC to totally freak out
For over two hours the upload hogged my PC before I gave up and rebooted. Then I tried sqlldr and it did the job in less than a minute.
Am I doing something wrong here? Is the functionality to copy and paste records in PL/SQL developer intended for larger amounts of records?
I know I can use sqlldr but...
When you want to upload records to a database you can copy and paste data directly in a table using Edit Data. I use this method as a fast way to get data from Excel to Oracle.
The amount of resources used by this functionality is extreme! Uploading a dataset of 40.000 records with 10 fields caused my PC to totally freak out
For over two hours the upload hogged my PC before I gave up and rebooted. Then I tried sqlldr and it did the job in less than a minute.Am I doing something wrong here? Is the functionality to copy and paste records in PL/SQL developer intended for larger amounts of records?
