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's (25.3) project export with emitSchema=false does not emit the schema for synonyms

M. Tr.Oct 9 2025

Hi everyone,

I'm trying to avoid including the schema name in my source code, but for synonyms, it seems to be required. When I set emitSchema=false, the schema name is omitted not only from the source but also from the target schema in the CREATE SYNONYM statement.
Is this a bug or desired behavior?

Best regards, Markus

Comments
Post Details
Added on Oct 9 2025
2 comments
84 views