Re: Table Renaming and Indexing Questions

You do not have to rebuild the indexes.

Have you tried SQL Loader in Direct Mode? We have loaded 4.5 million records in approx. 20 min using direct mode(O7.3.4 on AIX 4.2), where it would have take several hours(approx. 4hrs) to load the file otherwise.

HTH
Eric Peterson

In article <Pine.GSO.4.21.0007261816410.24995- 100000_at_grapevine.cc.utexas.edu>,
  <sambavan_at_motown.cc.utexas.edu> wrote:
> Hi Folks,
>
> In our work site, we need to insert data from a flat file in huge
> quatities into oracle 8.1.6 (solaris). The current way they do these
 load
> are through Perl and not SQL/LOADER. I know it is an inefficient way
 of
> doing things but we are working on the alternatives. The current load
> takes almost 11Hrs to load the huge data and the index building
 consumes
> half of the time even though it is in a different table space.
>
> My question at this point is that, I load these data into a dummy
> table and say I have built the index using this dummy table. Now if I
> rename the dummy table to some "XYZ" table, in the same table space,
 do I
> have to rebuild the indices that I built on the dummy table?
>
> Could some one tell me more about some work arounds on this case?
>
> -Sam
>
> -----------------------------------------------
>
> Experience is not what happens to a man, it's
> what a man does with what happens to him.
> -- ALDOUS HUXLEY
>
> ------------------------------------------------
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Jul 27 2000 - 00:00:00 CDT