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. -- //www.freelists.org/webpage/oracle-l