Re: sqlldr direct load: ORA-00942: table or view does not exist

From: Laurenz Albe <invite_at_spam.to.invalid>
Date: 08 May 2006 08:00:12 GMT
Message-ID: <1147075210.732999_at_proxy.dienste.wien.at>

sulakhe_at_gmail.com wrote:
> I have got access to Metaling now. But I am not very sure how to
> proceed.
> It mentiones about creating a public synonym for the table in question.
> But I have many such tables for which I want to use direct load. Is it
> a good practice to create too many public synonyms?
>
> Is there any other way? I don't see any patches for the bug?

I would try the workaround on one table and determine that way if this really is your problem.

If the workaround succeeds, you have some evidence that you actually hit the bug mentioned.

Then I would recommend that you open a service request via Metalink and ask Oracle what they suggest that you so. Include all your findings in the service request. Do not create the service request in the category 'other issues ...' because it will cause the service request to be processed slower.

Yours,
Laurenz Albe Received on Mon May 08 2006 - 10:00:12 CEST

This message: [ Message body ]
Next message: sybrandb_at_yahoo.com: "Re: about dbms_job"
Previous message: Eitan: "about dbms_job"
Maybe in reply to: sulakhe_at_gmail.com: "sqlldr direct load: ORA-00942: table or view does not exist"
In reply to sulakhe_at_gmail.com: "Re: sqlldr direct load: ORA-00942: table or view does not exist"
Next in thread: sulakhe_at_gmail.com: "Re: sqlldr direct load: ORA-00942: table or view does not exist"
Reply: sulakhe_at_gmail.com: "Re: sqlldr direct load: ORA-00942: table or view does not exist"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message