Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Global table alter

Global table alter

From: Randy Harris <please_at_send.no.spam>
Date: Fri, 07 Jul 2006 05:17:12 GMT
Message-ID: <s7mrg.167518$F_3.5986@newssvr29.news.prodigy.net> 





I need to alter the width of a field that appears in many tables.  Does 
anyone know of sample code that will search the entire schema for all 
tables with a field by that single name and modify it?  I'm using 9.2.0.6.



Thanks for any suggestions.


-- 
Randy Harris
tech at promail dot com


Received on Fri Jul 07 2006 - 00:17:12 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US