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 DIFF command generates empty artifact when comparing self-managed databases (not Autonomous)

Hi,

I have two schemas:

demo_rafal [let's say it's my DEV]

demo_rafal_test [my TEST]

Both schemas were created via the latest APEX 26.1

Oracle AI Database 26ai Enterprise Edition Release 23.26.2.2.0

(self-managed on OCI, not Autonomus)

sql /nolog

diff -source demo_rafal -target demo_rafal_test

Looks like all went well:

However, when trying to unzip the file, it looks like the zip file is empty

I reproduced the same steps on my Autonomous Database - all went well, no issues, and the zip is full of scripts.

Comments
Post Details
Added on May 25 2026
2 comments
114 views