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