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 export fails with "Failed to format, syntax error" on materialized expression column

Oleg PyatnychkoJun 7 2025

SQLcl: Release 25.1.1.0 Production Build: 25.1.1.113.2054

Added materialized expression column (23ai):

alter table TEST add (PERIOD timestamp as (trunc(START_DATE, 'mm')) materialized);

Export errors out with:

The current connection TEST will be used for all operations
*** TABLES ***
…

(run with -debug to get the full list)
============================================================
TABLE SCHEMA.TEST: Failed to format, syntax error
============================================================

Is there a way to bypass this until SQLcl adds support of materialized expression column?

This post has been answered by danmcghan-Oracle on Jun 10 2025
Jump to Answer
Comments
Post Details
Added on Jun 7 2025
2 comments
97 views