Re: Datapump question

we have the 11.2.0.4 version. In the doc I found no things about this limitation and the error message does not say much. Thank you Adric for this information

Adric Norris <landstander668_at_gmail.com> schrieb am Di. 22. Jan. 2019 um 21:02:

> I'm not sure what version you're on, but 11.2.0.4 had a limit of something
> like 8-10 columns (going from memory, so the exact number is a bit fuzzy).
> We opened a SR for it at the time, and Oracle's response was that you need
> to purchase Oracle Data Redaction if the built-in Datapump limit is
> insufficient.
>
> On Tue, Jan 22, 2019 at 11:47 AM Ahmed <gherrami_at_gmail.com> wrote:
>
>> 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