Re: ORA-14316 table is not partitioned by List method

"Andrea" <netsecurity_at_tiscali.it> wrote in message news:1175258561.593103.4500_at_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
>
>
> :(
>

It looks like the table is range partitioned. Try the following to check the DDL for
the table:

set long 20000
select dbms_metadata.get_ddl('TABLE','HA_EVENT_P','TEST_USER') from dual

Assumes you have execute privilege on dbms_metadata and suitable access to know about table HA_EVENT_P owned by user TEST_USER.

-- 
Regards
Jonathan Lewis
http://jonathanlewis.wordpress.com

Author: Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html