Skip to Main Content

SQLcl: MCP Server & SQL Prompt

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

project export of table fails with primary key defined with custom index name

Tim CarpenterDec 22 2025 — edited Dec 22 2025

If a table is defined with a primary key that is created from a custom index name then the export of that table fails.

This is a regression from 25.3.

Full example below:

SQL> create table TIM.SOME_TABLE (ID number, SOME_VALUE varchar2(10))
 2* ;
Table TIM.SOME_TABLE created.
SQL> alter table TIM.SOME_TABLE add constraint SOME_TABLE_PK primary key(ID) using index ( create unique index TIM.SOME_TABLE_PK0 on TIM.SOME_TABLE(id) ) enable novalidate;
Table TIM.SOME_TABLE altered.
SQL> project export -o TIM.SOME_TABLE
Exception in thread "DbmsMetadata# 10" java.lang.AssertionError: [94,286) overlaps with [189,266)
       at oracle.dbtools.parser.Substitutions.put(Substitutions.java:54)
       at oracle.dbtools.parser.Substitutions.put(Substitutions.java:80)
       at oracle.dbtools.parser.Substitutions.put(Substitutions.java:83)
       at oracle.dbtools.extension.project.commands.export.DbmsMetadata.transformTable(DbmsMetadata.java:887)
       at oracle.dbtools.extension.project.commands.export.DbmsMetadata$7.run(DbmsMetadata.java:1079)
SQL>
Comments
Post Details
Added on Dec 22 2025
1 comment
61 views