Re: SQLLDR Hanging

From: no spam <no_at_spam.com>
Date: Tue, 16 Nov 1999 16:30:01 GMT
Message-ID: <dEfY3.32210$m4.111216483@news.magma.ca>

You get the error when you log in as sys because you must put the user and table name in the control file.
ie user.table not just table

As for the load hanging that is another issue and you need to post you control file and sample data

Michael wrote in message <80i3gu$3v2$1_at_mail.pl.unisys.com>...
>I am using SQLLDR to load CSV data. I am running SQLLDR on the same
machine
>where the database resides. My load seems to hang when I log in using the
>loader with the table owner's login. When I try to do the load with system
>or sys, it responds with table/view not found. The load is 146 fields
about
>246 rows total. It should be quick. There are no messages in the bad or
>log files. I have to exit the DOS window to stop the process. I am not
>sure why this is happening.
>
>
Received on Tue Nov 16 1999 - 10:30:01 CST