index problem [message #61862] |
Mon, 07 June 2004 02:20 |
Raghavendra Prabhu
Messages: 1 Registered: June 2004
|
Junior Member |
|
|
hi,
By mistake the user had dropped the index .now how can i get the script of the original index to recreate it ?
|
|
|
Re: index problem [message #61870 is a reply to message #61862] |
Mon, 07 June 2004 06:37 |
N.A. Jam
Messages: 23 Registered: January 2003
|
Junior Member |
|
|
If no documentation that is available to do this, you can go back to your export to generate the create script from it.
Export files contains the create scripts of objects that was backup up.
Check command parameters of the import utility. Specifically look for the usage of the parameter called INDEXES. (do a "imp -help" to display parameter list)
Hope this helps.
|
|
|