Re: split partition (range partition) error

Sami,

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_at_gmail.com 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_at_evdbt.com> 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_at_gmail.com 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: table or view does not exist
>>> 

--
http://www.freelists.org/webpage/oracle-l