Datapump issue

From: Ahmed <gherrami_at_gmail.com>
Date: Tue, 22 Jan 2019 19:34:55 +0100
Message-ID: <CANkb5P2_1K=KvzuvGMRyU+96R2WXEqBSYGTRi4BCGSv52UGNaQ_at_mail.gmail.com>



Hello,

I tried to export a table with 20 columns using DBMS_DATAPUMP package. 11 columns should be anonymised. The anonymisation ist implemented in a package mypkg. I used dbms_datapump.data_remap:

dbms_datapump.data_remap(handle => h1, name => 'COLUMN_FUNCTION',

        table_name => 'TEST_TABLE', column => 'COL1', function => 'MYPKG.FU1', schema => USER);

It looks like it only works 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
Stuttgart, Germany

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jan 22 2019 - 19:34:55 CET

Original text of this message