Oracle Segment_drop_corrupt

Oracle Database Tips by Donald Burleson

Segment_drop_corrupt is a procedure that simply drops a segment marked as corrupt without reclaiming the space. For this to work, the segment should have first been marked as temporary by issuing a DROP command on it.

Table 6.107:  Segment_drop_corrupt Parameters

Segment_dump is a procedure that dumps the segment heard and bitmap blocks to user_dump_dest. The dump_option parameter may be either segment_dump_extent_map or segment_dump_bitmap_summary.

Table 6.108:  Segment_dump Parameters

Segment_verify verifies the consistency of the segment extent map against the tablespace bitmaps. The verify_option parameter may be either segment_verify_extents or segment_verify_extents_global. The output dump file is named sid_ora_process_ID.trc and in user_dump_dest.

Table 6.109:  Segment_verify Parameters

Tablespace_fix_bitmaps is a procedure that marks the extent as either free or used in the tablespace bitmap.

Table 6.110:  Tablespace_fix_bitmaps Parameters

Tablespace_fix_segment_states is a procedure that remedies the transient state of the segments in a tablespace in which a migration was aborted.

Table 6.111:  Tablespace_fix_segment_states Parameter

Tablespace_migrate_from_local is a procedure to migrate a tablespace from locally-managed to dictionary-managed.

Table 6.112:  Tablespace_migrate_from_local Parameter

Tablespace_migrate_to_local is a procedure to migrate a tablespace from dictionary-managed to locally-managed, which means user managed and not automatic segment space management. The relative file number parameter is used to place the bitmaps into a specified data file.

Table 6.113:  Tablespace_migrate_to_local Parameters

Tablespace_rebuild_bitmaps is a procedure that simply rebuilds the tablespace bitmaps. The relative file number parameter is used to place the bitmaps into a specified data file and the bitmap block to specify the block.

Table 6.114:  Tablespace_rebuild_bitmaps Parameters

Tablespace_rebuild_quotas is a procedure that simply rebuilds the tablespace quotas.

Table 6.115:  Tablespace_rebuild_quotas Parameter

Tablespace_relocate_bitmaps is a procedure that relocates the tablespace bitmaps to the specified destination.

Table 6.115:  Tablespace_relocate_bitmaps Parameters

Tablespace_verify is a procedure that verifies that the bitmaps and extent maps for all the segments in the tablespace are correct.

Table 6.116:  Tablespace_verify Parameters