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,
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-lReceived on Tue Jan 22 2019 - 19:34:55 CET