Oracle in a Nutshell

Calls

PROCEDURE DBMS_SPACE_ADMIN.SEGMENT_VERIFY (tablespace_name IN VARCHAR2, header_relative_file IN POSITIVE, header_block IN POSITIVE verify_option IN 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_name IN VARCHAR2, header_relative_file IN POSITIVE, header_block IN POSITIVE corrupt_option IN 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_name IN VARCHAR2, header_relative_file IN POSITIVE, header_block IN 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_name IN VARCHAR2, header_relative_file IN POSITIVE, header_block IN POSITIVE dump_option IN 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 ...