All Database objects like, tables,triggers,procedures,packages,functions,etc. are resided in tablespaces will naturally fragment as a function of update activity and Oracle has many methods for reclaiming disk space.
The Segment Advisor which will recommend us when database objects will get benefit from a reorganization to free up disk space.
Oracle has several tools to help reclaim disk space:
1 . Alter database datafile tempdb.dbf resize 50 M
This will remove spaces by physically. if the datafile, and this will not work, any of the segments of the tablespace are extended beyond your resize boundary. So, apply proper datafile size while using this.
2. Alter tablespace tempdb coalesce
This will reclaim space from honeycomb fragmentation.
The Segment Advisor which will recommend us when database objects will get benefit from a reorganization to free up disk space.
Oracle has several tools to help reclaim disk space:
1 . Alter database datafile tempdb.dbf resize 50 M
This will remove spaces by physically. if the datafile, and this will not work, any of the segments of the tablespace are extended beyond your resize boundary. So, apply proper datafile size while using this.
2. Alter tablespace tempdb coalesce
This will reclaim space from honeycomb fragmentation.
