Oracle Sql*loader-941 Error During Describe Of Table
Contents |
as checked? Unable to locate a valid ora 04043 error in oracle Sales Tax » SQL*Loader Error: SQL*Loader-941 ORA-04043 May
Ora-04043 Object Sys_plsql_ Does Not Exist
18, 2011 Ravindra Tripathi ========= Issue: ========= Getting following error message when trying ora-04043 drop user to import data using SQL Loader =============== Error Message: =============== SQL*Loader: Release 10.2.0.3.0 - Production on Tue May 17 15:39:15
Drop Package Ora-04043 Object Does Not Exist
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" ora 04043 object instances_util does not exist 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. « How to default the checkbox "Show Only Active Addresses" as che
and
Sys_plsql_ Objects
ORA-04043 Posted on August 19, 2010 by Michelle ora-00942 Perkins I had to import almost half of billion rows in one Oracle table http://blog.optiosys.com/?p=260 and for that I wrote a small SQLLoader script (below): "load data infile * append into table "usermonth....." And I received the following error message "SQL*Loader-941: Error http://blogs.adobe.com/digitalmedia/2010/08/sqlloader-and-ora-04043/ during describe of table "usermonth"
ORA-04043: object "usermonth" does not exist" After one hour of despair and I realized by pure luck that you need to provide the name of the table with upper case, otherwise the utility is not able to find it. Quite strange, but at least I'm happy that now it works. This entry was posted in External and tagged @seymour-feed-external by Michelle Perkins. Bookmark the permalink. Show Comments Hide Comments Comments are closed. No related posts.
FAQ by clicking the link above. You may have http://www.dbforums.com/showthread.php?1694477-SQL-Loader to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to http://motrasblog.blogspot.com/2013/12/sql-loader_6.html visit from the selection below. Results 1 to 2 of 2 Thread: SQL Loader Tweet Thread Tools Show Printable Version Subscribe to this Thread… does not Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 07-01-13,00:59 #1 satheeshsharma View Profile View Forum Posts Registered User Join Date May 2013 Posts 33 Unanswered: SQL Loader Microsoft Windows XP [Version 5.1.2600] (C) Copyright 1985-2001 Microsoft Corp. C:\Documents and Settings\Administrator>sqlplus system/database does not exist as sysdba SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jul 1 10:00:41 2013 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options Code: SQL> desc employee Name Null? Type ----------------------- -------- -------------- ID NUMBER FIRST_NAME VARCHAR2(20) LAST_NAME VARCHAR2(20) START_DATE DATE END_DATE DATE SALARY NUMBER CITY VARCHAR2(20) DESCRIPTION VARCHAR2(20) SQL> host Microsoft Windows XP [Version 5.1.2600] (C) Copyright 1985-2001 Microsoft Corp. C:\Documents and Settings\Administrator>notepad sample.ctl C:\Documents and Settings\Administrator>sqlldr system/database sample.ctl SQL*Loader: Release 10.2.0.1.0 - Production on Mon Jul 1 10:03:26 2013 Copyright (c) 1982, 2005, Oracle. All rights reserved. SQL*Loader-941: Error during describe of table EMPLOYEE ORA-04043: object EMPLOYEE does not exist C:\Documents and Settings\Administrator>sqlplus system/database SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jul 1 10:03:52 2013 Copyright (c) 1982, 2005, Oracle. All rights reserved. C
employee table as shown below. SQL> CREATE TABLE EMPLOYEE ( ID INTEGER, NAME VARCHAR2 (10), DEPT VARCHAR2 (15), SALARY INTEGER, HIREDAT DATE ) Next create the control file that explains what needs to be upload and where. LOAD DATA INFILE 'C:\Users\evosys\Desktop\loader\employee.txt' INSERT INTO TABLE "HR"."EMPLOYEE" FIELDS TERMINATED BY ',' (ID, NAME, DEPT, SALARY, HIREDAT) Note: If you have the values inside the data file enclosed with double quote, use this in your control file: fields terminated by "," optionally enclosed by ‘"‘ Note: If you don't have the table created, you'll get the following error message: SQL*Loader-941: Error during describe of table EMPLOYEE ORA-04043: object EMPLOYEE does not exist You can pass the userid and password to the sqlldr command using any one of the following format. As you see below, both of these will prompt you for control file location, as it was not given in the command line. $ sqlldr hr/hr (or) $ sqlldr userid=hr/hr control = SQL*Loader-287: No control file name specified. Execute the sqlldr command to upload this new record to the empty table by specifying both uid/pwd and the control file location as shown below. $ sqlldr hr/hr Control= C:\Users\evosys\Desktop\loader\emp_load.ctl Commit point reached - logical record count 5 Verify the the records are created in the database SQL> SELECT * FROM EMPLOYEE; ID NAME DEPT SALARY HIREDAT ---------- ---------- --------------- ---------- ------- 100 Thomas Sales 5000 200 Jason Technology 5500 300 Mayla Technology 7000 400 Nisha Marketing 9500 500 Randy Technology 6000 2. Inserting Additional Records Let us say you want to add two new employees to the employee table from the following newemployee.txt file. 600,Ritu,Accounting,5400 700,Jessica,Marketing,7800 If you create a similar control file like the previous example, you might get the following error message. $ sqlldr hr/hr Control= C:\Users\Desktop\loader\new_emp_load.ctl SQL*Loader-601: For INSERT option, table must be empty. Error on table EMPLOYEE The above indicates that the table should be empty before you can upload data using sql*loader. If you like to insert more data to the tables without having to delete the existing