Erwin: setting a property for all tables

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DrOlap - 30 Jan 2008 14:15 GMT

I'm trying to figure out how to set the tablespace for data and
indexes on all the tables of my Erwin model.
I know how to do it for one table, but I would like to avoid having to
edit the property for each table individually...
Has anyone found a solution to this problem?

Thanks,
Andrea

Reply to this Message

Peter Teoh - 31 Jan 2008 02:05 GMT

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.

Reply to this Message

DrOlap - 31 Jan 2008 10:00 GMT

> Don't use the GUI tool, instead use sqlplus and issue the following
> query:
[quoted text clipped - 4 lines]
>
> 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

Reply to this Message

Vince - 31 Jan 2008 15:26 GMT

> I'm trying to figure out how to set the tablespace for data and
> indexes on all the tables of my Erwin model.
[quoted text clipped - 4 lines]
> Thanks,
> Andrea

You may want to post such a question on a newsgroup that is specific
to your Erwin product. That being said, I know (at least newer
versions) of ER Studio come with a scripting language (VBA). You may
want to check that out.

Reply to this Message