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. >=20 > on 4/30/05 8:29 AM, Sami Seerangan at dba.orcl@xxxxxxxxx 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 > > -- //www.freelists.org/webpage/oracle-l