OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » URGENT: Index copy

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

URGENT: Index copy [message #56859]

Wed, 30 April 2003 19:14

Eudoro
Messages: 7
Registered: January 2003

Junior Member

I have 2 8i databases. I need to copy an index from db1 to db2. How can I do this?

Thank you,
Eudoro

Report message to a moderator

Re: URGENT: Index copy [message #56867 is a reply to message #56859]

Thu, 01 May 2003 05:54

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

you no need to copy the indexes.
just create a set of new indexes like the exising ones.

Report message to a moderator

Re: URGENT: Index copy [message #56869 is a reply to message #56859]

Thu, 01 May 2003 06:04

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

if you clearly know the type of index,and the indexed columns, you directly craete a new index in other database.
else
generate the ddl of index and run it against other database.

Report message to a moderator

Re: URGENT: Index copy [message #56889 is a reply to message #56867]

Fri, 02 May 2003 16:07

Eudoro
Messages: 7
Registered: January 2003

Junior Member

Thank you. I used the table dba_ind_columns to find out which fields were indexed, and recreated the indexes.

Report message to a moderator

Previous Topic:	multiple db
Next Topic:	upgrade db

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 30 15:51:00 CST 2024