Re: Index reorganization

From: Biju Thomas <bijuthomas_at_email.msn.com>
Date: 1998/11/29
Message-ID: <eaNGyVAH#GA.207@upnetnews05>#1/1

Instead of dropping and re-creating, consider ALTER INDEX... REBUILD .. TABLESPACE .. STORAGE (...); You can generate a script using the DBA views, DBA_INDEXES and DBA_IND_COLUMNS. Please let me know if you need help in this.

Biju

For Oracle Scripts, Tips and Links
http://www.geocities.com/SiliconValley/Peaks/4535/oracle_main.htm

Marco Mainini wrote in message <365FBE51.E018E4DD_at_realtech.de>...
>Hi,
> Can anybody help me please.
>I'm a relatively newbie DBA and I've to reorganize a tablespace
>containing 3000 indexes. Which is the fastest way to accomplish the
>work? How can I drop and recreate all the indexes?
>Thanks for any help in advance.
>
>
>Marco
>
>==============================
> Marco Mainini
> mailto:mainini_at_realtech.de
>==============================
>
>
Received on Sun Nov 29 1998 - 00:00:00 CST