Re: Erwin: setting a property for all tables

From: DrOlap <>
Date: Thu, 31 Jan 2008 02:00:58 -0800 (PST)
Message-ID: <>

On Jan 31, 3:05 am, Peter Teoh <> 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.

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

Original text of this message