split partition (range partition) error

From: Sami Seerangan <dba.orcl@xxxxxxxxx>
To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
Date: Sat, 30 Apr 2005 10:29:24 -0400

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

Follow-Ups:

Re: split partition (range partition) error
From: Tim Gorman

split partition (range partition) error

Other related posts: