Re: Index creation using a script

In article <31A5E52D.68A0_at_macromedia.com> Rich Headrick <rheadric_at_macromedia.com> writes:
>From: Rich Headrick <rheadric_at_macromedia.com>
>Subject: Index creation using a script
>Date: Fri, 24 May 1996 09:34:53 -0700
 

>Greetings,
 

>I need to create indexes on 440 tables in the same schema. Each table
>has a column name row_id, upon which I need to create the index.
>Storage contraints aren't important right now. What I need is a script
>which will process each table in the schema, and create the index on
>the column row_id.
 

>Any and all suggestions appreciated
 

>Rich

spool xxx.sql
select 'create index i'||table_name||' on '||table_name||'(row_id);' from user_tables;
spool off

then just clean the script and execute it.

Michel lalonde. Received on Fri Jun 07 1996 - 00:00:00 CEST