Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

sqlldr error message

208270Mar 4 2002
I'm running Oracle Server 8.1.6 under Windows2000.

I have two clients : A Oracle Client 8.1.6 and a Oracle Client 8.0.5

I have created a user MyUser.
I have created a table MyTable (into MyUser).
I have created a view MyView (This view is "select * from MyTable").

I have a ctl file that load data into the view.

When i run sqlldr (with userid=MyUser/MyPassword) on the Client 8.1.6, i have the following messages :
SQL*Loader-941: Error during describe of table MyView
ORA-04043: object MyView does not exist

When i run the same thing under Oracle 8.0.5 (with sqlldr80), it works fine.

If i run sqlldr under Oracle 8.1.6 with a ctl file that load data directly into the table MyTable, it works fine.

So I think that we can't use sqlloader with views anymore under Oracle 8i...

Can you help me ?
Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 1 2002
Added on Mar 4 2002
1 comment
413 views