Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from 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 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page