Hi Ahmed,
This is not my area of expertise, but did you try DBMS_DATAPUMP.GET_STATUS.
as suggested here:
[oracle@aftersalesdata-dvl ~]$ oerr ora 39001
39001, 00000, "invalid argument value"
// *Cause: The user specified API parameters were of the wrong type or
// value range. Subsequent messages supplied by
// DBMS_DATAPUMP.GET_STATUS will further describe the error.
// *Action: Correct the bad argument and retry the API.
?
On Tue, Jan 22, 2019 at 12:47 PM Ahmed <gherrami@xxxxxxxxx> wrote:
Hello,
I try to export a table using DBMS_DATAPUMP. The table has 20 columns and
I try to anonymise 11 columns using functions from package. Like this way:
dbms_datapump.data_remap(handle => h1, name => 'COLUMN_FUNCTION',
table_name => 'TEST_TABLE', column => 'COL1', function =>
'MYPKG.FU1', schema => USER);
but it seems that work only for 10 columns.
If I try to anonymize more than 10 columns I get ORA-39001 invalid input
argument at datapump job definition.
Is this a bug or maybe a restriction? Any Idea?
Best Regards
Ahmed Fikri
Senior Developer
Stuttgart, Germany