Oracle8i Supplied PL/SQL Packages Reference
Release 2 (8.1.6)

Part Number A76936-01

Library

Product

Contents

Index

Go to previous page Go to next page

50
DBMS_SPACE_ADMIN

The DBMS_SPACE_ADMIN package provides functionality for locally managed tablespaces.

Security

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

Constants

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 next page
Oracle
Copyright © 1996-2000, Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index