Print Thread
Text Importer ...
#39071 11/19/10 02:38 PM
Joined: Mar 2007
Posts: 4
Prague - Czech Republic
P
petrf Offline OP
Member
OP Offline
Member
P
Joined: Mar 2007
Posts: 4
Prague - Czech Republic
Hi

If I use function "Text Importer ..." (menu Tools) then PLSQL Developer freeze (under Windows 7) tell "Not Responding" in title bar. This freeze comming after import processed about 1700 rows. This behavior is both for buttons "Import" and "Import to Script". But in the second instance of PLSQL Developer I see that first instance still working or the SQL file on disk increasing...

Code
PL/SQL Developer
  Version 8.0.4.1514
  01.59953 - Unlimited user license
  Windows 7 (64-bit) 6.1 Build 7600

Re: Text Importer ...
petrf #39072 11/19/10 03:42 PM
Joined: Nov 2001
Posts: 29
Columbia Univ in New York, NY ...
Member
Offline
Member
Joined: Nov 2001
Posts: 29
Columbia Univ in New York, NY ...
It's always done that for me, too... It *appears* to be frozen, but the import continues... it's just that the window is no longer being updated. It will update again (and un-freeze) once the import is complete.

Re: Text Importer ...
kamrath #39077 11/22/10 08:10 AM
Joined: Mar 2007
Posts: 4
Prague - Czech Republic
P
petrf Offline OP
Member
OP Offline
Member
P
Joined: Mar 2007
Posts: 4
Prague - Czech Republic
I hope that it's true, but my text file have over 12000000 lines and I waiting and waiting ...


[quote]I used Oracle tool "sqlldr" for import this large text file and I save a lot of time.[/quote]

Last edited by petrf; 11/22/10 10:23 AM.

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.029s Queries: 14 (0.009s) Memory: 2.5053 MB (Peak: 3.0428 MB) Data Comp: Off Server Time: 2024-05-18 21:45:33 UTC
Valid HTML 5 and Valid CSS