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 -> Re: Global table alter

Re: Global table alter

From: Carlos <miotromailcarlos_at_netscape.net>
Date: 6 Jul 2006 23:40:05 -0700
Message-ID: <1152254405.210102.97200@75g2000cwc.googlegroups.com>

Randy Harris wrote:
> 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

You can start SELECTing from dba_tab_columns and some DDL via DYNAMIC sql perhaps...

HTH. Cheers.

Carlos. Received on Fri Jul 07 2006 - 01:40:05 CDT

Original text of this message

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