Yes, EM has it as an option www.oracle.com/technology/products/oem/pdf/ds_datamasking.pdf ..but these are definitely worth looking at as well.. Datamasker at http://www.datamasker.com/ Camouflage at http://www.datamasking.com/ As a side note, I do think that our industry in general needs to be more precise about what we mean by the word "datamasking" though i.e. do we mean "data-covering" e.g. through a view OR do we mean "data-sanitising" the actual original data itself, OR "obfuscating" a copy of the data, OR generally "editing" the data as in redaction. Of special interest IMO are data sets that are created independently of the production data e.g. a table of new credit card numbers which have been generated completely independently of the original data using the Luhn Formula as described for the layman at this URL. http://www.moneybluebook.com/how-to-create-and-generate-valid-credit-card-numbers/ These newly generated CC numbers can (nearly) be guaranteed never to be production CC numbers. Regards, Paul ~http://issdconference.com/ Tracy Rahmlow wrote: > > We are currently looking to mask some data in a 500g 10.2.0.4 database > and I'm looking for design options from this group. We are considering > the use of functions to update some rows in place and/or CTAS with > function calls. Anybody have any other thoughts? > > Thanks > >> > > > > > > > > *Tracy Rahmlow* | Lead Database Analyst | Infrastructure Delivery Services > > Ameriprise Auto & Home Insurance | 3500 Packerland Drive | De Pere, WI > 54115-9070 > Ameriprise Insurance Company | IDS Property Casualty Insurance Company > Office: 920.330.5164 | Fax: 920.330.5350 | _ameriprise.com/autohome_ > <https://www14.ameriprise.com/AutoQuoteWebInter/AQFrontServlet?request_type=un_auth_init&PartnerID=AMPF&RefID=11m-at> > > ----------------------------------------- > ****************************************************************************** > "This message and any attachments are solely for the intended recipient > and may contain confidential or privileged information. If you are not > the intended recipient, any disclosure, copying, use, or distribution of > the information included in this message and any attachments is > prohibited. If you have received this communication in error, please > notify us by reply e-mail and immediately and permanently delete this > message and any attachments. Thank you." > ****************************************************************************** > -- //www.freelists.org/webpage/oracle-l