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?