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

Home -> Community -> Usenet -> c.d.o.server -> ORA-14316 table is not partitioned by List method

ORA-14316 table is not partitioned by List method

From: Andrea <netsecurity_at_tiscali.it>
Date: 30 Mar 2007 05:42:41 -0700
Message-ID: <1175258561.593103.4500@n59g2000hsh.googlegroups.com>


I don't able to drop value for table partitioned:

ALTER TABLE HA_EVENT_P MODIFY PARTITION ENTRO_MARZO02 DROP VALUES (TO_DATE('01-0-1/2005','DD-MM-YYYY')); ORA-14316 table is not partitioned by List method

why??

SELECT HIGH_VALUE FROM USER_TAB_PARTITIONS; HIGH_VALUE



TO_DATE(' 2005-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'
MAXVALUE :( Received on Fri Mar 30 2007 - 07:42:41 CDT

Original text of this message

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