Home » RDBMS Server » Server Administration » index problem
index problem [message #61862] Mon, 07 June 2004 02:20 Go to next message
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 Go to previous message
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.
Previous Topic: Help please.
Next Topic: Oracle 10g Compatabality
Goto Forum:
  


Current Time: Fri Sep 20 14:23:45 CDT 2024