How can we help you today? How can we help you today?

Unable to count local partitions for index

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
...
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?
robert_mbcl
1

Comments

2 comments

Sort by
  • JoshH
    Have you tried adding the explicit partition definition to the index in the repository?
    JoshH
    0
  • danyhp
    JoshH said:
    Have you tried adding the explicit partition definition to the index in the repository?
    Can you explain how to do this? I am experiencing same issues here, when i try to save schema model with LOCAL index in it
    danyhp
    0

Add comment

Please sign in to leave a comment.