Manipulate locally managed tablespaces.
Subprocedures: SEGMENT_VERIFY Verify the consistency of the extent map of the segment. SEGMENT_CORRUPT Mark the segment corrupt or valid so that appropriate error recovery can be done. SEGMENT_DROP_CORRUPT Drop a segment currently marked corrupt (without reclaiming space). SEGMENT_DUMP Dump the segment header and extent map(s) of a given segment. TABLESPACE_VERIFY Verify that the bitmaps and extent maps for the segments in the tablespace are in sync. TABLESPACE_FIX_BITMAPS Mark the appropriate DBA range (extent) as free or used in bitmap. TABLESPACE_REBUILD_BITMAPS Rebuild the appropriate bitmap(s). TABLESPACE_REBUILD_QUOTAS Rebuild quotas for given tablespace. TABLESPACE_MIGRATE_FROM_LOCAL Migrate a locally-managed tablespace to dictionary-managed tablespace. TABLESPACE_MIGRATE_TO_LOCAL Migrate a tablespace from dictionary managed format to locally managed format. TABLESPACE_RELOCATE_BITMAPS Relocate the bitmaps to the destination specified. TABLESPACE_FIX_SEGMENT_STATES Fix the state of the segments in a tablespace in which migration was aborted.
For full documentation of the packaged procedures above see the Oracle Manual:
"Oracle9i Supplied PL/SQL Packages and Types Reference"
or the book Oracle Built in Packages by Steven Feuerstein et al
© Copyright SS64.com 1999-2013
Some rights reserved