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

"Andrea" <netsecurity@xxxxxxxxxx> wrote in message
news:1175258561.593103.4500@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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



.

Relevant Pages

  • Re: Join cardinality
    ... If your 'different start points for each country' ... LIST partitioning - you have a LIST of countries, ... Another reason for not using the partition views is that I have ... The Co-operative Oracle Users' FAQ ...
    (comp.databases.oracle.server)
  • Re: Why Does Query Require Table Access
    ... partition elimination occurs in both cases. ... answer the query without hitting the table. ... If you want a predicate SHOULDN'T visit the table, ... The Co-operative Oracle Users' FAQhttp://www.jlcomp.demon.co.uk/faq/ind_faq.html ...
    (comp.databases.oracle.server)
  • Re: Why Does Query Require Table Access
    ... partition elimination occurs in both cases. ... answer the query without hitting the table. ... If you want a predicate SHOULDN'T visit the table, ... The Co-operative Oracle Users' FAQ ...
    (comp.databases.oracle.server)
  • ORA-14316 table is not partitioned by List method
    ... ALTER TABLE HA_EVENT_P MODIFY PARTITION ENTRO_MARZO02 DROP VALUES ... ORA-14316 table is not partitioned by List method ...
    (comp.databases.oracle.server)