Skip Headers

Oracle9i Supplied PL/SQL Packages and Types Reference
Release 2 (9.2)

Part Number A96612-01
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

DBMS_SPACE_ADMIN, 2 of 3


Constants for DBMS_SPACE_ADMIN Constants

Table 68-1 DBMS_SPACE_ADMIN Constants
Constant Description

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.


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 2000, 2002 Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback