Database Tuning (MOSC)

MOSC Banner

ORA-14651: reference partitioning constraint is not supported

edited Apr 25, 2011 2:21AM in Database Tuning (MOSC) 2 commentsAnswered
 Hi,
I have a table partitioned by LIST, and when I try to create other table with reference parttiong, it returns me:

SQL> CREATE TABLE APMETER.PAR_AGE_DIAS
  2    (
  3      AGE_ID NUMBER NOT NULL,
  4      FECHA DATE,
  5      HORAMAXDIA DATE,
  6      HUECOS NUMBER,
  7      CONSTRAINT ADC_AGE_FK FOREIGN KEY (AGE_ID) REFERENCES APMETER.AGE_AGENDAS (AGE_ID))
  8    PARTITION BY REFERENCE(ADC_AGE_FK);
CREATE TABLE APMETER.PAR_AGE_DIAS_CITAS
*
ERROR at line 1:
ORA-14651: reference partitioning constraint is not supported

The original table has 5526 rows. If I create a original table empty and then I create the reference partitioning table again, it runs ok.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center