| Index copy [message #72278] |
Wed, 30 April 2003 19:10  |
Eudoro
Messages: 7
Registered: January 2003
|
Junior Member |
|
|
I have 2 Oracle 8i databases in one server, and I need to copy (or create) the same indexes from db1 to db2. How can I do this?
Thanks,
Eudoro
|
|
|
|
| Re: Index copy [message #72282 is a reply to message #72278] |
Thu, 01 May 2003 10:11  |
Anand
Messages: 161
Registered: August 1999
|
Senior Member |
|
|
You need to extract the DDL from the source database and run it in the destination database.
The best way is to run an export for this particular user with ROWS=N and INDEXFILE="file_name". This will create a script for creating all the indexes. You can use this file to create the indexes in the 2nd DB.
hth
|
|
|
|
| Re: Index copy [message #72298 is a reply to message #72282] |
Fri, 02 May 2003 16:04 |
Eudoro
Messages: 7
Registered: January 2003
|
Junior Member |
|
|
I went with looking at the columns in dba_ind_columns table, and recreating the indexes.
Thank you for your help.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
