Re: Erwin: setting a property for all tables
- From: DrOlap <andrea.vincenzi@xxxxxxxxxx>
- Date: Thu, 31 Jan 2008 02:00:58 -0800 (PST)
On Jan 31, 3:05 am, Peter Teoh <htmldevelo...@xxxxxxxxx> 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
.
- References:
- Erwin: setting a property for all tables
- From: DrOlap
- Re: Erwin: setting a property for all tables
- From: Peter Teoh
- Erwin: setting a property for all tables
- Prev by Date: Walk-in interviews in Boostrap on 2rd, 3rd and 4th Feb 2008
- Next by Date: Re: What is "exceeds notification threshold"?
- Previous by thread: Re: Erwin: setting a property for all tables
- Next by thread: Re: Erwin: setting a property for all tables
- Index(es):
Relevant Pages
|
|
