Table of Contents
This chapter briefly introduces the DBMS_SPACE_ADMIN package, and describes how to use the procedures of the package.
This section describes the procedure provided by the DBMS_SPACE_ADMIN package.
The following are the constants that can be defined for the DBMS_SPACE_ADMIN package:
Dumps information about the segment header and bitmap blocks.
Information about the dump is saved to the location set in the
USER_DUMP_DEST parameter, and can be located using
the ALTER SYSTEM DUMP DEST statement.
Details about the SEGMENT_DUMP procedure are as follows:
Prototype
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
);
Parameter
| Parameter | Description |
|---|---|
| tablespace_name | Tablespace name of the segment. |
| header_relative_file | Relative file number of the segment header. |
| header_block | Segment header block number. |
| dump_option | One of:
|
Example
BEGIN
DBMS_SPACE_ADMIN.SEGMENT_DUMP('TS', 3, 9,
DBMS_SPACE_ADMIN.SEGMENT_DUMP_EXTENT_MAP);
END;