From: wouldnt_you_like@to_know.com   
      
   On Fri, 30 Jan 2004 22:28:59 -0700, "Shawn"    
   wrote:   
      
   >Hi,   
   >   
   >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'   
   >/   
   >   
      
   Check out EXECUTE IMMEDIATE in the documentation.   
      
      
   --   
   Bob Hairgrove   
   NoSpamPlease@Home.com   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)