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!

SQLcl project deploy - Problem with indexes creation

Alexandre CourchesneFeb 24 2025 — edited Feb 24 2025

I've started working pour the project command and I've got an issue with the table creation and indexes.

The thing that when I export then stage, the indexes are duplicated. There is one line in the table definition of and there is another in indexes/.

Example :

dist/
  releases/
    0.0.8/
      changes/
        release-0.0.8/
          schema1/
            table/
              table_u01.sql
            index/
              table.sql

The file table.sql contain the definition of the table AND the indexes definition. The file table_u01.sql contain another definition of the index. The problem is that when I run my migration, it fails since the create index table_u01… cannot be ran the times.

Is there a fix for this behavior?

This post has been answered by Alexandre Courchesne on Feb 25 2025
Jump to Answer
Comments
Post Details
Added on Feb 24 2025
2 comments
153 views