Home » RDBMS Server » Server Utilities » sqlldr error message
sqlldr error message [message #368234] Fri, 06 October 2000 12:54 Go to next message
tzivia
Messages: 1
Registered: October 2000
Junior Member
I am trying to load a file into a table by going in as the owner of the table.
I am recieving the following error message

SQL*Loader-925: Error while parsing a cursor (via ocisq3)
ORA-00942: table or view does not exist

The table definiately exists. Can it be a permission issue?
Re: sqlldr error message [message #368303 is a reply to message #368234] Tue, 07 November 2000 10:09 Go to previous message
Shane J. Fabianek
Messages: 3
Registered: November 2000
Junior Member
HiTzivia,
I had the same problem and come to find out I forgot to setup the logical pointer to the database which I wanted to load in. We are on Win NT 4.0 server so , I had to c:\ set oracle_sid= SID_NAME

Hope this helps,
Shane J. Fabianek
Previous Topic: Export/Import
Next Topic: SQL script - Start command
Goto Forum:
  


Current Time: Thu Mar 28 03:36:46 CDT 2024