Path: news.easynews.com!core-easynews!newsfeed1.easynews.com!newsfeed2.easynews.com!easynews.com!easynews!newsfeed.news2me.com!arclight.uoregon.edu!logbridge.uoregon.edu!news-feed.riddles.org.uk!sn-xit-03!sn-xit-01!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: Sybrand Bakker Newsgroups: comp.databases.oracle.misc Subject: Re: The object does not exist Date: Tue, 06 May 2003 06:38:49 +0200 Organization: Posted via Supernews, http://www.supernews.com Message-ID: Reply-To: postbus@sybrandb.demon.nl References: <3EB725C8.5AE@maxinter.net> X-Newsreader: Forte Agent 1.93/32.576 English (American) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Complaints-To: abuse@supernews.com Lines: 29 Xref: core-easynews comp.databases.oracle.misc:97354 X-Received-Date: Mon, 05 May 2003 21:38:13 MST (news.easynews.com) On Mon, 05 May 2003 23:02:32 -0400, C Chang 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