Re: Problem with sqlldr

Rich Tsui <tsui_at_cbmi.upmc.edu> wrote in article <346A3B48.755B245A_at_cbmi.upmc.edu>...
> I got problems when running sqlldr. The situation is that I load a
> plain-file table (with 4880 records)
> to Oracle via sqlldr and then the sqlldr hangs after showing
> "commit point reached - logical record count 4240". BTW, I used the
> conventional path to load the
> table. Well, I also tried the direct path, but the system just hangs
> right away. (even worth!)

Direct path does not hang right away - it simply does not display anything until the load completes or falls over.

It's strange that loader seems to hangs. What does the loader log file say? Have you checked the alert_SID.log file? Maybe there's some other problem like Oracle waiting for the redo logs to be manually archived? We regulary load millions of rows into Oracle using loader and it very seldom give problems - and I've never seen it just hanging. If it hits an error, it always bombs out in my experience. So if it hangs, there may be an underlaying Oracle or operating system problem that causes the loader to wait for some kind of response.

regards,
Billy Received on Tue Nov 18 1997 - 00:00:00 CST