SQL*Loader Error: SQL*Loader-941 ORA-04043

=========
Issue:
=========
Getting following error message when trying to import data using SQL Loader

===============
Error Message:
===============
SQL*Loader: Release 10.2.0.3.0 – Production on Tue May 17 15:39:15 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.
SQL*Loader-941:
Error during describe of table “XXSFDC”.”xxsfdc_import_kb”
ORA-04043: object “XXSFDC”.”xxsfdc_import_kb” does not exist

=============================================
Old Control File:xxsfdc_import_tempdata.ctl
=============================================
OPTIONS ( ERRORS=1000)
LOAD DATA
INFILE ‘C:\Users\rtripathi\Desktop\kbContent051711.csv’
BADFILE ‘C:\Users\rtripathi\Desktop\kbContent051711.bad’
DISCARDFILE ‘C:\Users\rtripathi\Desktop\kbContent051711.dsc’

INTO TABLE “XXSFDC”.”xxsfdc_import_kb”
APPEND
FIELDS TERMINATED BY ‘,’
OPTIONALLY ENCLOSED BY ‘”‘ AND ‘”‘
TRAILING NULLCOLS
(id,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
data_source
)
===============
Solution:
===============

Verify table name in your database.
If table exist then update your control file with table name in upper case.

=============================================
New Control File:xxsfdc_import_tempdata.ctl
=============================================
OPTIONS ( ERRORS=1000)
LOAD DATA
INFILE ‘C:\Users\rtripathi\Desktop\kbContent051711.csv’
BADFILE ‘C:\Users\rtripathi\Desktop\kbContent051711.bad’
DISCARDFILE ‘C:\Users\rtripathi\Desktop\kbContent051711.dsc’

INTO TABLE “XXSFDC”.”XXSFDC_IMPORT_KB
APPEND
FIELDS TERMINATED BY ‘,’
OPTIONALLY ENCLOSED BY ‘”‘ AND ‘”‘
TRAILING NULLCOLS
(id,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
data_source
)

This entry was posted in Database.

4 Responses to SQL*Loader Error: SQL*Loader-941 ORA-04043

  1. Marketta Rattner says:

    You wrote some good parts here. I searched for the topic and found plenty of people who agree with you.

  2. Pingback: Sql Loader 941 Error

  3. Pingback: Oracle Sql*loader-941 Error During Describe Of Table

  4. Pingback: Sql Loader-941 Error During Describe Of Table Ora-04043