Re: Erwin: setting a property for all tables
From: DrOlap <andrea.vincenzi_at_tiscali.it>
Date: Thu, 31 Jan 2008 02:00:58 -0800 (PST)
Message-ID: <c170c787-772f-48b4-a908-31cfa3b98b3d@s12g2000prg.googlegroups.com>
Date: Thu, 31 Jan 2008 02:00:58 -0800 (PST)
Message-ID: <c170c787-772f-48b4-a908-31cfa3b98b3d@s12g2000prg.googlegroups.com>
On Jan 31, 3:05 am, Peter Teoh <htmldevelo..._at_gmail.com> wrote:
> 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.
Peter,
I think you are suggesting to use sqlplus to issue a command on my
Oracle database to change the desired properties, right? I know how to
do that, but that's not what I want to do. What I want is to change
the tablespace property for all tables and indexes IN THE PHYSICAL
MODEL OF MY ERWIN FILE, not on the database.
Andrea
Received on Thu Jan 31 2008 - 04:00:58 CST