Sample Header Ad - 728x90

Get current-processed column information in Oracle datapump

1 vote
0 answers
270 views
In order to mask data I am using REMAP_DATA parameter in Oracle datapump as follows: expdp \'/ as sysdba\' DIRECTORY=DUMP_DIR DUMPFILE=dumpfile.dmp LOGFILE=logfile.log SCHEMAS=user0 REMAP_DATA=user0.table1.col1:user0.pckg_mask.fun_mask REMAP_DATA=user0.table2.col2:user0.pckg_mask.fun_mask REMAP_DATA=user0.table1.col3:user0.pckg_mask.fun_mask This is just an example. Instead of creating and deploying individual functions for different columns I am using fucnction overload method hence using the same function name but with different input parameter datatype. But some columns need special logic for masking and the logic is stored in a central table. **So, is it possible that I can know which column is being processed by datapump and from which column it will take export next? (So that I can deploy the logic at run-time for that column which is being exported currently)** The question might be vague or complicated. Please do ask for needed information or any suggestion for improving question quality.
Asked by Bibhuti Bhusan Padhi (347 rep)
Aug 17, 2017, 07:27 AM