I am currently using the below script to generate another sql script to
scramble all columns in our development databases.
The problem I'm having are the larger tables are erroring with "...rollback
segment...". So, it was suggested that I create
a dynamic PL/SQL script to commit after every 1000 rows. They problem I'm
having (not being a PL/SQL export for one),
but apparently you can't use the table name as a variable. So, I'm having
problems getting it started so I can update all
tables with this common column. I'd appreciated any pointers.
Thanks!
set pages 0
spo scramble_ssns.sql
select 'update '||table_name||' set '||column_name||' = TRANSLATE
(''915482376'',''123456789'',TRANSLATE('||column_name||',
''1234567890'',''9732581406''));'
from user_tab_columns where column_name = 'SSN'
/