Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: IndexFiles (RE)CREATING

Re: IndexFiles (RE)CREATING

From: MMK Productions <nospam.mmkprod_at_bellatlantic.net>
Date: Tue, 23 Jun 1998 22:03:33 -0400
Message-ID: <6mpmtp$4mm@world6.bellatlantic.net>


Are you on 7.3? You can recreate indexes 'in place' using the rebuild option. You can even more the index to a new TS or change the STORAGE clause.

EnviroTech_Pumpsystems_the_Netherlands_B.V. wrote in message ...
>
>I'am searching a script that automatily reindex existing Index files.
>Normaliter I using exp and imp user/passwd file=expdat.dmp
>indexfile=create_index.sql
>Then i edit the file and run the script.
>We are using 2000 tables as you can see why I want a script.
>
>Suggestions are welcome to:
>
>Geert van Lierop
>etps_at_euronet.nl
>
>
>
Received on Tue Jun 23 1998 - 21:03:33 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US