Re: IndexFiles (RE)CREATING

From: Rainer Scheel <rainer.scheel_at_sno.drs1.x400.sni.de>
Date: Mon, 22 Jun 1998 10:12:06 +0200
Message-ID: <358E11D5.B8AA5E4D@sno.drs1.x400.sni.de>

From SQL*Plus, try something like
set pagesize 0
spool 'rebuild_i.sql'
select 'alter index ' || index_name || ' rebuild;' from user_indexes; spool off
@rebuild_i.sql

EnviroTech_Pumpsystems_the_Netherlands_B.V. wrote:

> 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 Mon Jun 22 1998 - 03:12:06 CDT