Bug #2861165 seems to be a "hit" on your symptoms and it indicates that a workaround is to explicitly grant SELECT ANY TABLE to the user in question; apparently the problem is fixed in 10g.
-Tim
on 4/30/05 3:13 PM, Sami Seerangan at dba.orcl@(protected) wrote:
> Tim, > > Thanks for your reply. It is not a privilege problem. Just before this > operation I did add/drop partition. I have dba rights. The error is > misleading. > > > On 4/30/05, Tim Gorman <tim@(protected)> wrote: >> Look at the error message. Just because you have SELECT privileges on >> DBA_TAB_PARTITIONS and DUAL does not mean you have any privileges at all on >> the DWO.PART_TAB table. >> >> on 4/30/05 8:29 AM, Sami Seerangan at dba.orcl@(protected) wrote: >> >>> Could someone please tell me what is wrong here?=20 >>> >>> alter table dwo.part_tab split partition P20050601 at (TO_DATE(' >>> 2005-05-11 00:00:00','SYYYY-MM-DD HH24:MI:SS', >>> 'NLS_CALENDAR=3DGREGORIAN')) INTO ( partition P20050511, partition >>> P20050601) >>> * >>> ERROR at line 1: >>> ORA-00942 (See ORA-00942.ora-code.com): table or view does not exist >>> >
