Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: IndexFiles (RE)CREATING
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