I recently performed a large delete in tables of an Oracle database. The database is used in production and should be always online. (7x24) Which of the following methods would you recommend me to use to shrink size without corrupting indexes and disturbing on-going operations?
1.Create Table As Select
2.Online Reorg Using DBMS_REDEFINITION
3.Alter Table Move
4.Alter Table Shrink Space