Hello, community.
I'm starting to explorer the datapumpt functionality of sqlcl and it seems pretty interesting. This in fact solves a kind of nasty problem I have with the regular datapump executable on my local machine client: I have to deal with some older database versions, and I frequently hit the incompatibility of versions error, mine being newer than the server itself. This requires me to use the remote datapupmp version on the server itself.
sqlcl easily circumvents this limitation by performing the export/import using the server side datapump API.
However, I'm getting a weird issue with the EXCLUDELIST option:
SQL> DATAPUMP IMPORT -DIRECTORY dba_temp_refersh -SCHEMAS GEM -DUMPFILE GEM_P10X_20250226_094540_%U.DMP
-LOGFILE impdp_GEM_P10X_20250226_094540.log -excludelist DBLINK,SYNONYM,STATISTICS -PARALLEL 8
Aucune valeur n'est fournie pour le paramètre requis excludelist
DataPump : impossible de traiter la demande. Vérifiez les options indiquées :
Parameters
basecommand : datapump
command : import
directory : DBA_TEMP_REFERSH
dumpfile : GEM_P10X_20250226_094540_%U.DMP
logfile : impdp_GEM_P10X_20250226_094540.log
schemas : GEM
End Parameters
Sorry for the french, but the error translates to “no value was given to the required parameter excludelist”.
I thought it might have been the comma, but even using one single value gives the same error. I tried both single and double quoting the values, but no luck, always the same error.
The command executes perfectly without the parameter.
Just for the records, this problem happens with the import as well as the export; the parameter gives the same error on both operations.
SQLcl : version 24.1 Production
Am I doing something wrong, or maybe there is a bug?