ALTER INDEX name UNUSABLE;

ALTER INDEX name REBUILD...;



-----Original Message-----
From: Ramakrishna Devaraju
[mailto:oracledba-ezmlmshield-x58335561.[Email address protected]
Sent: Tuesday, August 03, 2004 1:45 PM
To: LazyDBA Discussion
Subject: How can I recreate indexes, when needed






Hi,

Is there an easy way of recreating indexes with all of the current default
parameters?

Thanks.

Ramakrishna Devaraju
Sr. Systems Analyst/Primary Oracle DBA
CSC Financial Services Group, Logic
8616 Freeport Parkway 1, Suite 2B357
Irving, TX 75063
Phone: (469) 499-8999
Cell: (214) 704-2366



----------------------------------------------------------------------------------------

This is a PRIVATE message. If you are not the intended recipient, please
delete without copying and kindly advise us by e-mail of the mistake in
delivery. NOTE: Regardless of content, this e-mail shall not operate to
bind CSC to any order or other contract unless pursuant to explicit written
agreement or government initiative expressly permitting the use of e-mail
for such purpose.
----------------------------------------------------------------------------------------




--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page