Very good reading on this subject can be found on Richard Foote's blog.. http://richardfoote.wordpress.com/2008/04/16/separate-indexes-from-tables-some-thoughts-part-i-everything-in-its-right-place/ http://richardfoote.wordpress.com/2008/04/18/separate-indexes-from-tables-some-thoughts-part-ii-there-there/ http://richardfoote.wordpress.com/2008/04/23/separate-indexes-from-tables-some-thoughts-part-15-think-for-yourself/ http://richardfoote.wordpress.com/2008/04/28/indexes-in-their-own-tablespace-availabilty-advantages-is-there-anybody-out-there/ http://richardfoote.wordpress.com/2008/05/02/indexes-in-their-own-tablespace-recoverability-advantages-get-back/ It covers pretty much everything you need to know about this index/data tablespace(s) story.. ciao. -- Nilo Segura Oracle Support - IT/DES CERN - Geneva Switzerland
