| SQL*LOADER -941 Error and ORA-04043 [message #73798] |
Tue, 13 July 2004 13:37  |
mitra fatolahi
Messages: 38
Registered: October 2002
|
Member |
|
|
Hi All,
In my earlier message that i posted today, i explained in detail what my table, load.ctl, data.csv file are like and the error i was getting every time i was trying to load data from a csv file with comma delimited. The error ORA-01722 Invalid number. Please refer to my earlier message for the detail with subject line SQL*LOADER Error-Invalid number.
I modified my csv data file and replaced all FALSE and TRUE values to "0" and "1" respectively. My guess was this time the SQL*LOADER should work. I tried to load the data again using the Load data from file link in Oracle 10g EM.
This time i am getting a different error:
SQL*Loader-941: Error during describe of table SECUR_PARMS
ORA-04043: object SECUR_PARMS does not exist
I am logged on to the EM with the username and password who owns the object (SECUR_PARMS). And the table does exist when i searched for it in the EM.
Can someone please help me out as to why SQL*LOADER is giving me the error that the object does not exist.
PLEASE HELP!
Thank you,
Mitra
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
