Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: moving indexes to another machine
Although the indexes effectively have to be recreated as others have stated,
the easiest way to do this is to get the details from the source database's
data
dictionary via a db link. Interrogate the ALL_INDEXES (or USER_INDEXES)
view to
determine the indexes available, then get all the columns in each index via
ALL_IND_COLUMNS.
Then it's straightforward to generate the CREATE INDEX statement and execute
it
on the target database using dynamic SQL.
If you'd like the source code for this, email me directly.
Eugene Ng wrote in message <86it7s$9vh$1_at_clematis.singnet.com.sg>...
>Hi, I was wondering if any of you can help me out.
>
>Is there any way that we can index a table on one machine, and then move or
>copy the index to another machine which has the same table ?
>
>If so, how can we do that ??
>
>Thanks !
>
>---------------------------------------------------------------------
>
>Samuel Shio
>Global Sources
>
>
Received on Tue Jan 25 2000 - 03:02:47 CST