I recently joined a small company running Oracle 8.1.6 on NT.
All tables are partitioned to 4 tablespaces. I am not sure whether these are hash or range partitions. The data in these tables are relatively small and the tablespaces are still using the first extent. The tablespaces are however 90% full but I think the space was taken up by the first extent right from the start. These empty spaces are taking a lot of space during backup and the CEO wants me to to something about it.
1. Should I remove 3 of these 4 tablespaces from backup?
2. How can I claim back these empty tablespaces?
3. How can I find out the type of partition used for these tables.
Click Here to Expand Forum to Full Width