TABLESPACEMIGRATETOLOCAL - Migrates locally managed tablespace to dictionary-managed - Oracle Tablespaces

Q.  What migrates a locally managed tablespace to dictionary-managed in Diagnosing and Repairing Locally Managed Tablespace Problems?
- Published on 12 Aug 15

a. TABLESPACE_MIGRATE_TO_LOCAL
b. TABLESPACE_REBUILD_QUOTAS
c. TABLESPACE_MIGRATE_FROM_LOCAL
d. TABLESPACE_VERIFY

ANSWER: TABLESPACE_MIGRATE_TO_LOCAL
 

    Discussion

  • Nirja Shah   -Posted on 31 Aug 15
    - Oracle Database includes the DBMS_SPACE_ADMIN package, which is a collection of aids for diagnosing and repairing problems in locally managed tablespaces.

    - The following table lists the DBMS_SPACE_ADMIN package procedures.

    - TABLESPACE_MIGRATE_TO_LOCAL - Migrates a dictionary-managed tablespace to a locally managed tablespace

    - TABLESPACE_REBUILD_QUOTAS - Rebuilds quotas for a specific tablespace

    - TABLESPACE_MIGRATE_FROM_LOCAL - Migrates a locally managed tablespace to dictionary-managed tablespace

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

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.)