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.

"project export" is missing workspace export and ORDS modules

Roel HartmanJan 16 2025

Using sqlcl’s “project export” command I am able to export most of my applications. But not all ….I am missing

  • a Workspace export - and then the workspace files in particular
  • my ORDS modules

ORDS :
Regarding the ORDS modules : running the export in debug mode reveals this error
Failed to export ords due to ORA-20857: Error retrieving parsing schema information - ORA-01403: no data found
ORA-06512: at “ORDS_METADATA.ORDS_EXPORT”, line 1092
ORA-06512: at “ORDS_METADATA.ORDS_EXPORT”, line 1155
ORA-06512: at “ORDS_METADATA.ORDS_EXPORT”, line 1167
I am running the export as PDB_ADMIN and that is assigned the ORDS_ADMINISTRATOR_ROLE - so what am I missing to get the ORDS modules out?
FYI, running that query as the “owner” of the ORDS Modules does return the correct data.

Workspace export:
I can add a custom file for the workspace and include that in my changelog as
<include file=“code/_custom/w1700184007129478.sql” relativeToChangelogFile=“true”/>
but as this file contains multipl anonymous PL/SQL blocks, the deployment fails with an “ORA-00900: invalid SQL statement” error.

I could also include similar for the exported files
<include file=“code/_custom/files_1700184007129478.sql” relativeToChangelogFile=“true”/>
but as these might change more frequently, I would love to see that included in a (regular) “project export” command. (edited)

This post has been answered by danmcghan-Oracle on Jan 19 2025
Jump to Answer

Comments

BluShadow Mar 18 2024

Oracle support documents are available to paying customers through the support portal: support.oracle.com

If you are not a paying customer then I'm afraid you won't have access to the document, and it is a breach of any customer's agreement with Oracle to supply such support documents to others.

1 - 1

Post Details

Added on Jan 16 2025
2 comments
134 views