Text Importer Freezing

[da bull]

I'm using version 7.1.5 on an Oracle 10g database and whenever I need to create a temp table and Import a .CSV file, if it is over about 15k rows, PL/SQL will go (Not Responding) and eventually have to be killed. I can upload the same file in other apps in seconds. Is there some setting in PL/SQL I can change to make it Import Text smoother? I like the ease at which I can create tables and would like to be able to load them just as easily.
Thanks

 

[Marco Kalter]

To obtain some more diagnostic information, can you modify the shortcut and add the debugsql parameter? For example:

"C:\Program Files\PLSQL Developer\plsqldev.exe" debugsql

Reproduce the problem and send me the debug.txt file that is generated in the PL/SQL Developer directory.

 

[da bull]

I have made the change and ran the Text Importer. The Debug file is about 31mb. I have zipped it down to under 1mb, but do not see where I can attach a file to this thread. Is there somewhere I can send it.
thanks

 

[Marco Kalter]

You can send it to support@allroundautomations.com.

 

[da bull]

I have sent the file this morning. well, my morning anyway.

 

[juanian]

Has anything been found related to this issue? It has plagued me since version 7 (and I am now using 9).

What I have seen is the following: After clicking Import, the cursor turns into a spinning circle (Windows 7/64-bit), and the number of imported records increments in the status bar. After a few hundred (or thousand) records are processed, the incrementing record count stops, and PL/SQL Developer goes into the "(Not Responding)" state. The records will continue to be imported even when PL/SQL Developer is not responding. In my cases, eventually it does complete the import (if it is left running long enough).

I'm guessing that MS Windows is noticing that PSD is not responding to events, and is assuming that the app is hung. When in this state, it is not processing the window updates, and the incrementing counter appears to freeze.

When doing an import, is there *supposed* to be any keyboard interaction allowed? For example, can someone change windows and do editing while another window is importing, or is PSD supposed to be 'hung' while an import is occurring?