Sybrand Bakker wrote:
>
> On Mon, 05 May 2003 23:02:32 -0400, C Chang <cschang_at_maxinter.net>
> wrote:
>
> >I have created a table and the view of the table. Then I specifically
> >grant privilege of INSERT, SELECT, UPDATE to the view for a user
> >account. But When I use this user to insert into the
> >schema.view_of_table from a sql loader process, system said "the object
> >does not exist". The sql loader is sqlldr80 from 8.0.5 client and my
> >server is 8.1.6 on NT4. I am sure there is no porblem of such setting,
> >because there is another table and its view will work with such insert
> >process ( from the sqlldr80). Both use a very similar control file
> >except the view of the INSERT INTO TABLE is different. I open the
> >shcema using the DBA studio and compared , found no different setting or
> >grant-privilege between those two tables and views. Do I missed
> >anything when I set the new table and its view?
> >
> >C Chang
>
> Views are compiled.
> Now you fill in the rest from the Google archives. Answer is posted
> many times per week.
> Both your client and server sw have been desupported and 816 is known
> to be a can of worms.
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
After I reinstalled the 8.0.5 client, it works now. Thanks.
C Chang
Received on Tue May 06 2003 - 21:32:20 CDT
