TABLESPACEREBUILDBITMAPS - Definition,Features - Oracle Tablespaces

Q.  Which tasks call the procedure, either on all bitmap blocks, or on a single block if only one is corrupt in a set of bitmap blocks that has media corruption?

- Published on 12 Aug 15

a. TABLESPACE_REBUILD_QUOTAS
b. TABLESPACE_REBUILD_BITMAPS
c. TABLESPACE_VERIFY
d. None of the above

ANSWER: TABLESPACE_REBUILD_BITMAPS
 

    Discussion

  • Nirja Shah   -Posted on 31 Aug 15
    - To diagnose and repair corruptions in Locally Managed Tablespaces Oracle has supplied a package called DBMS_SPACE_ADMIN.

    - TABLESPACE_REBUILD_QUOTAS - Rebuilds quotas for given tablespace.

    - TABLESPACE_REBUILD_BITMAPS - Rebuilds the appropriate bitmap. Cannot be used for a locally managed SYSTEM tablespace.

    - TABLESPACE_VERIFY - Verifies that the bitmaps and extent maps for the segments in the tablespace are in sync.

Post your comment / Share knowledge


Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)