Cry How To...


Move an index to a different tablespace


To move an index to a different tablespace:

Alter index <index-name> rebuild
    tablespace <new-tablespace>;


This page represents one page of many pages of notes I made whilst working with Oracle 7 through to 10i. I now no longer work with Oracle databases, but hope that these notes will continue to be of benefit to others.



About the author: is a dedicated software developer and webmaster. For his day job he develops websites and desktop applications as well as providing IT services. He moonlights as a technical author and consultant.