Re: Index creation using a script
Date: 1996/05/25
Message-ID: <4o82qb$ib0_at_hasle.sn.no>#1/1
On Fri, 24 May 1996 09:34:53 -0700, Rich Headrick <rheadric_at_macromedia.com> wrote:
Hello.
Use SQL*Plus to make a script for you;
SPOOL INDEX.SQL;
SELECT 'create index ' || table_name||'on'||table_name||'(row_id);'
from user_tables;
SPOOL OFF;
Yous disable set heading and other things like that, to leave onl th
requested out in your file....
hilsen jan
>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
Received on Sat May 25 1996 - 00:00:00 CEST