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)