Re: Datapump question

Hi Ahmed,

This is not my area of expertise, but did you try DBMS_DATAPUMP.GET_STATUS. as suggested here:
[oracle_at_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.

> 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
>

--
http://www.freelists.org/webpage/oracle-l