Re: DATA P0PULAT1ON

Data population means bringing data from production to QC / UAT / Development environments. Make sure you scramble sensitive data like SSN , DOB, Routing# , Salary etc as the case may be ; The difficulty lies in scrambling RELATED data (eg) SSN in table A of Employee is present in Table W, Table G; Therefore when you scramble SSN to a different value the same scrambled value needs to go to Table W and Table G for that particular employee. Depends on the Constraints in the schema. VPD/FGAC may not be of much use since it blanks out the values; Hence scrambling. Methodology might vary depending on the need.

HTH GovindanK

On Tue, 11 Dec 2007 03:06:47 +0530, "Anant (DBA)" <shastry17_at_gmail.com> s aid:

  Hi all,
  Can any please suggest me what is data population in Oracle   database?
  User has requested , Data population from Prod to dev   instance.
  Does this mean a data refresh of tables from prod to dev?   Thanks,
  Ann

--
http://www.freelists.org/webpage/oracle-l