Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 536.4K On-Premises Infrastructure
- 138.3K Analytics Software
- 38.6K Application Development Software
- 5.8K Cloud Platform
- 109.5K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
Compression decreasing the freespace

JamesMichaelRaj
Member Posts: 1
When i compress a table in oracle using (ALTER TABLE Table_Name MOVE PARTITION Partition_Name TABLESPACE table_space COMPRESS) query.
When we compress a table, freespace should be increase...ya for some table freespace is increasing...
For some table freespace is decreasing.
instead of increase in freespace, compression decreasing the freespace.
Why freespace is decreased for compressing some table ?What is the reason?
This discussion has been closed.