Re: Question: cleaning up PK indexes

If you have unix or perl tools at your disposal, a quick way could be to exp ... rows=n, imp ... show=y and then grep for PRIMARY to sort things into good and bad files. Or something like that. The idea is, you wind up with scripts you can globally make consistent in your favorite editor, and while you are at it, fix PCT* and INITIAL and so forth. Sometimes just seeing it all together points out other overlooked problems.

platforms and versions can be important: http://www.dbaoracle.net/readme-cdos.htm

jg

--
@home.com is bogus.
Sounds like Lead Dog will go over like a Lead Zeppelin:
http://www.signonsandiego.com/uniontrib/20050430/news_1b30hp.html