用sqlldr 导入数据时出现 不能描述表 FEED 错误

 

http://www.orafaq.com/forum/t/26937/2/

 

http://cornelcreanga.com/2010/07/sqlloader-and-ora-04043/

 

i spent lot of time nearly 9 hours in two days to resolve the problem. didn't get any help from net. Really frustrated. finally i got the answer.
ans: use uppercase for the tablename.

 

 

I had to import almost half of billion rows in one Oracle table 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 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.

 

 

 

但是我修改了也不成

 

http://www.cryer.co.uk/brian/oracle/ORA04043.htm

 

Symptom:

The following error when trying to access a table:

ORA-04043: object SSS.NNN does not exist

Where ‘SSS’ is the name of a schema and ‘NNN’ the name of a table.

Possible causes and remedies:

• Check that the table does exist and that it is spelt correctly.
• Check the creator/owner of the object, it may be that the table exists but is in a different schema from the current. If the table is in a different schema then try specifying the schema explicitly.
• Check the permissions – specifically that the account experiencing the error has permissions to select the object/table in question.

---

This page represents one page of many pages of notes I made whilst working with Oracle 7 through to 10i. I now no longer work with Oracle databases, but hope that these notes will continue to be of benefit to others.

 

 

 

 

****************************************************************

终于找到了，在baidu上，

1. 执行的时候让运行sqlldr的目录和实际存放ctl文件的目录相同。例如：ctl文件放在'd:\ssjk.ctl'，那么运行ctl的时候cmd就切换到d盘下。
2 运行ctl的时候，sqlldr  userid=SYSTEM/admin@SID   control='d:\ssjk.ctl'
把你建DB的SID也加上。例如
sqlldr  userid=username/password@orcl control='d:\ssjk.ctl'

 

 

-------------------------------------------------------------------------------------------------------------------------

出现ORA-12154: TNS:could not resolve the connect identifier specified

 

http://forums.oracle.com/forums/thread.jspa?messageID=4459783&tstart=0

 

http://forums.oracle.com/forums/thread.jspa?threadID=956313

 

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:431775600346873836

 

 You say there is no connection problem - but obviously there is one; you just have to work out why.

1) check the connect string; can you use the same string from the same user and directory, and with the same environment, with SQL*Plus (eg use command line sqlplus - starting plus from an icon may set the environment differently

sqlplus user/password@dbglobal

2) check the service by using tnsping:

tnsping dbglobal

3) Does the failure stop the import immediately?
Yes: the definition of dbglobal you give may be incorrect - perhaps you are picking up the wrong tnsnames.ora

No: do some objects get imported successfully? Are there any database links in the export that you are importing? If so, this error message could be generated if the database links used a connect string that wasn't recognised by your Oracle server.

4) Are you using a local or a remote database? If it is remote, remember that its own tnsnames.ora may be different from yours (that can also happen with a local database, depending on ORACLE_HOME settings etc).

Try all those and see if that helps

Regards Nigel

http://kr.forums.oracle.com/forums/thread.jspa?threadID=844217

http://bytes.com/topic/oracle/answers/64191-connectstring-sql-loader 

 

 

 

查看当前实例名

select instance_name from v$instance