Calls
-
PROCEDURE DBMS_SPACE_ADMIN.SEGMENT_VERIFY(tablespace_nameIN VARCHAR2,header_relative_fileIN POSITIVE,header_blockIN POSITIVEverify_optionIN POSITIVE DEFAULT SEGMENT_VERIFY_EXTENTS); For tablespace_name, with relative file number of header_relative_file and block number of header of header_block, uses verify_option of either SEGMENT_VERIFY_EXTENTS or SEGMENT_VERIFY_EXTENTS_GLOBAL to verify the segments.
-
PROCEDURE DBMS_SPACE_ADMIN.SEGMENT_CORRUPT(tablespace_nameIN VARCHAR2,header_relative_fileIN POSITIVE,header_blockIN POSITIVEcorrupt_optionIN POSITIVE DEFAULT SEGMENT_MARK_CORRUPT); For tablespace_name, with relative file number of header_relative_file and block number of header of header_block, uses corrupt_option of either SEGMENT_MARK_CORRUPT or SEGMENT_MARK_VALID to check the segments.
-
PROCEDURE DBMS_SPACE_ADMIN.SEGMENT_DROP_CORRUPT(tablespace_nameIN VARCHAR2,header_relative_fileIN POSITIVE,header_blockIN POSITIVE); Drops a segment marked as corrupt in tablespace_name, with the relative file number of header_relative_file and the block number of header of header_block.
-
PROCEDURE DBMS_SPACE_ADMIN.SEGMENT_DUMP(tablespace_nameIN VARCHAR2,header_relative_fileIN POSITIVE,header_blockIN POSITIVEdump_optionIN POSITIVE DEFAULT SEGMENT_DUMP_EXTENT_MAP); The segment residing in tablespace_name, with relative file number of header_relative_file and block number of header of header_block, dumps the segment header and extent block maps. There is only one ...