Re: Erwin: setting a property for all tables
From: Peter Teoh <htmldeveloper_at_gmail.com>
Date: Wed, 30 Jan 2008 18:05:51 -0800 (PST)
Message-ID: <588c549a-44d5-4202-8107-0fecd9ad2441@n20g2000hsh.googlegroups.com>
Date: Wed, 30 Jan 2008 18:05:51 -0800 (PST)
Message-ID: <588c549a-44d5-4202-8107-0fecd9ad2441@n20g2000hsh.googlegroups.com>
Don't use the GUI tool, instead use sqlplus and issue the following
query:
select 'alter table ' || table_name || ' xxxxxxx;' from user_tables;
where xxxx is the attribute of the table u want to modify.
Or something like this. Received on Wed Jan 30 2008 - 20:05:51 CST