Hello,
I am "reposting" the original question from an achived discussion at: Partition table issue (where there were some replies but it didn't solve my issue) one last time to get an answer for this, maybe someone will figure out what happens. (DDL is on the original post)
I am trying to add partition(s) to an already partitioned table - partitioned that are done starting with 2011-01-01. First two partitions are:
PARTITION "C_INVOICE_BEF_ALL" VALUES LESS THAN (TO_DATE(' 2011-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) ,
PARTITION "C_INVOICE_JAN2011" VALUES LESS THAN (TO_DATE(' 2011-02-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
---
---SQL USED
---
ALTER TABLE C_INVOICE SPLIT PARTITION C_INVOICE_aft_all AT (TO_DATE('01/02/2016','DD/MM/YYYY')) INTO (PARTITION C_INVOICE_jan2016,PARTITION C_INVOICE_aft_all ) UPDATE GLOBAL INDEXES;
And i get the following error:
Error starting at line 1 in command:
ALTER TABLE C_INVOICE SPLIT PARTITION C_INVOICE_aft_all AT (TO_DATE('01/02/2016','DD/MM/YYYY')) INTO (PARTITION C_INVOICE_jan2016,PARTITION C_INVOICE_aft_all ) UPDATE GLOBAL INDEXES Error report:
SQL Error: ORA-00604: error occurred at recursive SQL level 1
ORA-00957: duplicate column name
00604. 00000 - "error occurred at recursive SQL level %s"
*Cause: An error occurred while processing a recursive SQL statement
(a statement applying to internal dictionary tables).
*Action: If the situation described in the next error on the stack
can be corrected, do so; otherwise contact Oracle Support.
Any ideeas what is wrong?
P.S. The table C_INVOICELINE is partitioned by reference ( PARTITION BY REFERENCE ("C_INVOICELINE_C_INVOICE_ID_FK") )
---
CONSTRAINT "C_INVOICELINE_C_INVOICE_ID_FK" FOREIGN KEY ("C_INVOICE_ID") REFERENCES "C_INVOICE" ("C_INVOICE_ID") ENABLE