Unable to count local partitions for index
RobertMBCL
Posts: 1 New member
I am trying to create a local index on a partitioned table using SCO and a set of schema scripts and receive the error:
Failed to parse file C:\..\CURR\Indexes\LMEREFIT_MBU_TRD_REGS_IDX1.sql - Unable to count local partitions for index.
The sql in the index file is
CREATE INDEX CURR.LMEREFIT_MBU_TRD_REGS_IDX1 ON CURR.LMEREFIT_MBU_TRD_REGS (UNIQUE_TRANSACTION_ID) LOCAL;
while the table in question is partitioned
...
Failed to parse file C:\..\CURR\Indexes\LMEREFIT_MBU_TRD_REGS_IDX1.sql - Unable to count local partitions for index.
The sql in the index file is
CREATE INDEX CURR.LMEREFIT_MBU_TRD_REGS_IDX1 ON CURR.LMEREFIT_MBU_TRD_REGS (UNIQUE_TRANSACTION_ID) LOCAL;
while the table in question is partitioned
...
PARTITION BY RANGE (REPORT_DATE)
INTERVAL (NUMTOYMINTERVAL(1, 'MONTH'))
(
PARTITION p0 VALUES LESS THAN (TO_DATE('2023-01-01', 'YYYY-MM-DD'))
);
Obviously the index can be created in SQL Developer, but now our scripts don't match the schema.
I get the same error if I compare the schema scripts to an earlier version. What is causing this error?
Obviously the index can be created in SQL Developer, but now our scripts don't match the schema.
I get the same error if I compare the schema scripts to an earlier version. What is causing this error?
Tagged:
Answers