PL/SQL Packages DBMS_IOT

Create tables into which references to chained rows/exceptions for an index organized table can be placed.

Subprocedures:

BUILD_CHAIN_ROWS_TABLE  Create a table into which references to the chained rows
                        for an index-organized table can be placed using the ANALYZE command.  

BUILD_EXCEPTIONS_TABLE  Create an exception table into which rows of an index-organized table
                        that violate a constraint can be placed during the enable_constraint operation.  

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
Related Commands:

ANALYZE



 
Copyright © 1999-2024 SS64.com
Some rights reserved