sqlldr error message
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.