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 - reducing `project export -objects` run duration for large schemas

Arvydas Ko4 days ago

Hello,

Are there any tips or guidance on how to reduce project export command run duration?

Goal is to introduce SQLcl usage while working with old schemas that contain many objects. For example, working with a schema where initial export generated around 5000 scripts.

I've tried using -objects option (project export -o ..) to export only specified objects. However, this still resulted in the export command running for around 100 seconds to export a single object.

Given the reluctance of other developers to adopt new tools, long-running commands seem like a reasonable argument on why they will avoid using SQLcl. I would like to make the experience of using SQLcl as smooth as possible.

Regards,
Arvydas

Comments
Post Details
Added 4 days ago
6 comments
54 views