Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: split partition (range partition) error

Re: split partition (range partition) error

From: Sami Seerangan <dba.orcl_at_gmail.com>
Date: Sat, 30 Apr 2005 17:13:13 -0400
Message-ID: <f09dd62805043014136d8cef13@mail.gmail.com>


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.

>=20

> on 4/30/05 8:29 AM, Sami Seerangan at dba.orcl_at_gmail.com wrote:
>=20

> > Could someone please tell me what is wrong here?=3D20
> >
> > 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=3D3DGREGORIAN')) INTO ( partition P20050511, partition
> > P20050601)
> > *
> > ERROR at line 1:
> > ORA-00942: table or view does not exist
> >
--
http://www.freelists.org/webpage/oracle-l
Received on Sat Apr 30 2005 - 17:17:31 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US