Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Table Renaming and Indexing Questions
answer embedded.
-- Have a nice day Michel <sambavan_at_motown.cc.utexas.edu> a écrit dans le message : Pine.GSO.4.21.0007261816410.24995-100000_at_grapevine.cc.utexas.edu...Received on Thu Jul 27 2000 - 00:00:00 CDT
> 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?
You have not to rebuild the indices but you have to recreate the synonyms on the table with the new name.
>
> 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
>
> ------------------------------------------------
>