Re: Index creation using a script

In article <31A5E52D.68A0_at_macromedia.com> Rich Headrick <rheadric_at_macromedia.com> wrote:

> 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

One possibility if all of the tables are under one owner is to create a cursor that will read the name of the table from the user_tables view. Loop through the cursor and then use the dynamic sql package to parse a create index statement on each table.

Good luck,
mark Received on Sat May 25 1996 - 00:00:00 CEST