Database 11g & 12c
Hi ALL,
Anybody here have experience in purging data and reclaiming space in database?
Can you please advice which program option/choice/style is effective or efficient in reclaiming space from tables after purging data?
Example Scripts to Reclaim Freespace
1. create table...as select
2. alter table....move
3. alter table....shrink space
4. online table re-definiton
5. rebuild indexes
Are there other options aside from above?
Please help....
Kind regards,
jc