Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Data mask using expdp/impdp

751640Nov 16 2010 — edited Nov 19 2010

Hi,

I'm trying to mask the data during the import on 11gr1 AIX 5.3.I have tables called as tableA and tableB which have sensitive data on table A:Col1 and table B:Col1 and col2.I have created a function called pkg_mask.fn_tabA_col1,pkg_mask.fn_tabB_col1 and pkg_mask.fn_tabB_col2 owned by X.

userid=userid/pwd
directory=x
dumpfile=test.dmp
logfile=test.log
remap_schema=A:B
remap_data=A.tableA.Col1:X.pkg_mask.fn_tabA_col1
remap_data=A.tableB.Col1:X.pkg_mask.fn_tabB_col1
remap_data=A.tableB.Col2:X.pkg_mask.fn_tabB_col2

But when i check the data-its not scrambled or masked as i used dbms_random.value and dbms_random.string in the function.

Can i have mulitple columns for remap as shown above in my parfile.

Any suggestions please....

Thanks

Edited by: user9097501 on Nov 16, 2010 6:42 PM