Re: split partition (range partition) error
- From: Tim Gorman <tim@xxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Sat, 30 Apr 2005 15:56:05 -0600
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@xxxxxxxxx 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@xxxxxxxxx> 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@xxxxxxxxx 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
>>>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
