Skip to Main Content

SQLcl

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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
54 views