Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Table Renaming and Indexing Questions
sambavan_at_motown.cc.utexas.edu schrieb:
>
> Hi Folks,
>
> 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
Halo Sam
don't rename the dummy table use a alias for this dummy table , so you
definitely don't have to rebuild the indexes.
Jens Loebling Received on Thu Jul 27 2000 - 00:00:00 CDT