When a table becomes out of sync with reality and you have to perform some open-heart surgery on your database, you might be happy with a good assistant like DBMS_REDEFINITION at your side. This Oracle package will let you change most aspects of a table while the table is still in use. This is done, by creating a copy of the original table and switching the original and duplicate tables once all changes have been completed. The package utilizes the snapshot (or materialized view) technology within the Oracle database. This is a good summary on how to go about reorganizing tables with the DBMS_REDEFINITION package.
Restrictions: Be aware, that this package will not work on tables which already have snapshots (MViews) defined.
