GurcanK
asked on
Shrinking Size of Tables in Oracle
Dear experts,
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
BR,
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
BR,
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.