Originally posted by slimdave
Take the opportunity to order the result of the select from dba_indexes by table_name -- if you're just going to run the generated script you'll get some performance benefits.
I know I shouldn't even touch this with a 10 foot pole, but...

Why?