Re: split partition (range partition) error

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
> 
> SQL> select TO_DATE(' 2005-05-11 00:00:00','SYYYY-MM-DD HH24:MI:SS',
> 'NLS_CALENDAR=3DGREGORIAN') from dual;
> =20
> TO_DATE('
> ---------
> 11-MAY-05
> =20
> select table_owner,TABLE_NAME,PARTITION_NAME,HIGH_VALUE from
> dba_tab_partitions where table_owner=3D'DWO' and table_name=3D'PART_TAB'
> 
> returns 27 record.

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

Other related posts: