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 25.2 project - bitmap indexes missing in export

Moritz I.Aug 11 2025 — edited Aug 12 2025

Dear SQLcl experts,

i just realized that SQLcl command project export ignores all our bitmap-indexes.

Using the debug-option i found the responsible line in the ALL_INDEXES Query:

and (All_indexes.index_type in ('NORMAL','FUNCTION-BASED NORMAL','DOMAIN','FUNCTION-BASED DOMAIN','NORMAL/REV')) --<-- sqlcl internal.fixed.filters

Since this filter is internal i can not do much about it through project.filters file to include other index-types, or is there a way to overwrite this internal filter?

Is there a way to still get them exported?

This post has been answered by thatJeffSmith-Oracle on Aug 15 2025
Jump to Answer
Comments
Post Details
Added on Aug 11 2025
2 comments
55 views