Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: IndexFiles (RE)CREATING
I would import the indexes diectly from the export file ( not the data !), Create an 'empty' export file - (no data exported) to speed this up.
It sounds like you will have a long wait for this to run , your database
will have to be
carefully tuned. Increase sort_area_size parameter etc.
With that number of indexes to create it would be worth experimenting to
find out how much you can do
in parallel .ie have two or more index builds happening at once . How
feasible this is depends on
the power of your server . I doubt that more than two could run at once
without using up all CPU power.
EnviroTech_Pumpsystems_the_Netherlands_B.V. <etps_at_euronet.nl> wrote in
article <etps.4.00160126_at_euronet.nl>...
>
> 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 - 21:18:11 CDT