61
DBMS_SPACE_ADMIN

The DBMS_SPACE_ADMIN package provides functionality for locally managed tablespaces.

Oracle9i Database Administrator's Guide for an example and description of using DBMS_SPACE_ADMIN.

This chapter discusses the following topics:

Security and Constants for DBMS_SPACE_ADMIN

This package runs with SYS privileges; therefore, any user who has privilege to execute the package can manipulate the bitmaps.

SEGMENT_VERIFY_EXTENTS	Verifies that the space owned by segment is appropriately reflected in the bitmap as used.
SEGMENT_VERIFY_EXTENTS_ GLOBAL	Verifies that the space owned by segment is appropriately reflected in the bitmap as used and that no other segment claims any of this space to be used by it.
SEGMENT_MARK_CORRUPT	Marks a temporary segment as corrupt whereby facilitating its elimination from the dictionary (without space reclamation).
SEGMENT_MARK_VALID	Marks a corrupt temporary segment as valid. It is useful when the corruption in the segment extent map or elsewhere has been resolved and the segment can be dropped normally.
SEGMENT_DUMP_EXTENT_MAP	Dumps the extent map for a given segment.
TABLESPACE_VERIFY_ BITMAP	Verifies the bitmap of the tablespace with extent maps of the segments in that tablespace to make sure everything is consistent.
TABLESPACE_EXTENT_MAKE_ FREE	Makes this range (extent) of space free in the bitmaps.
TABLESPACE_EXTENT_MAKE_ USED	Makes this range (extent) of space used in the bitmaps.

Subprogram	Description
"SEGMENT_VERIFY Procedure"	Verifies the consistency of the extent map of the segment.
"SEGMENT_CORRUPT Procedure"	Marks the segment corrupt or valid so that appropriate error recovery can be done.
"SEGMENT_DROP_CORRUPT Procedure"	Drops a segment currently marked corrupt (without reclaiming space).
"SEGMENT_DUMP Procedure"	Dumps the segment header and extent map(s) of a given segment.
"TABLESPACE_VERIFY Procedure"	Verifies that the bitmaps and extent maps for the segments in the tablespace are in sync.
"TABLESPACE_FIX_BITMAPS Procedure"	Marks the appropriate DBA range (extent) as free or used in bitmap.
"TABLESPACE_REBUILD_BITMAPS Procedure"	Rebuilds the appropriate bitmap(s).
"TABLESPACE_REBUILD_QUOTAS Procedure"	Rebuilds quotas for given tablespace.
"TABLESPACE_MIGRATE_FROM_LOCAL Procedure"	Migrates a locally-managed tablespace to dictionary-managed tablespace.
"TABLESPACE_MIGRATE_TO_LOCAL Procedure"	Migrates a tablespace from dictionary managed format to locally managed format.
"TABLESPACE_RELOCATE_BITMAPS Procedure"	Relocates the bitmaps to the destination specified.
"TABLESPACE_FIX_SEGMENT_STATES Procedure"	Fixes the state of the segments in a tablespace in which migration was aborted.