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!

APEX export does not create any files

Leandro LimaDec 4 2024 — edited Dec 4 2024

I just started playing with the APEX component of SQLcl and the export/import feature got my attention, so I started testing it, but I can't generate any export.

SQLcl : version 24.1

SQL> apex version
APEX Version 22.1.6 is installed.
SQL> APEX export -expWorkspace -expOriginalIds -expPubReports -expSavedReports -expIRNotif -expTranslati
ons 
Exporting Workspace 2512422548933210:'*******'

 SQL> host dir
Page de codes active : 1252
Le volume dans le lecteur C s’appelle Windows
Le numéro de série du volume est A0F2-A104
Répertoire de C:\Users\******\Documents\exp_apex
2024-12-03  21:43    <DIR>          .
2024-12-03  21:08    <DIR>          ..
              0 fichier(s)                0 octets
              2 Rép(s)  128 979 238 912 octets libres
SQL>

I understood that some files should be generated locally? In fact, following some tutorials, upon launching the APEX export command I think there should be some message of files being created?

I investigated with -debug to see if there were more info:

SQL> APEX export -expWorkspace -expOriginalIds -expPubReports -expSavedReports -expIRNotif -expTranslati
ons -debug
Exporting Workspace 2512422548933210:'*****'
 begin
     ? := apex_export.get_workspace (
              p_workspace_id          => ?,
              p_with_team_development => ?='Y',
              p_with_misc             => ?='Y',
              p_with_date             => ?='Y' );
 end;
 Start Tue Dec 03 21:55:16 EST 2024
SQL> 

But that's all it spits out. No error nor success message, neither any export file. Just some obscure anonymous block with a function to get the workspace, nothing else.

Anyone has an idea? Am I doing something wrong? Maybe I should set some parameters before exporting?

Comments
Post Details
Added on Dec 4 2024
4 comments
561 views