Oracle9i Supplied PL/SQL Packages and Types Reference
Release 1 (9.0.1)

Part Number A89852-02
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to next page

18
DBMS_IOT

The DBMS_IOT package creates a table into which references to the chained rows for an index organized table can be placed using the ANALYZE command. It can also create an exception table into which rows of an index-organized table that violate a constraint can be placed during the enable_constraint operation.

This chapter discusses the following topics:

Summary of DBMS_IOT Subprograms

Table 18-1 DBMS_IOT Package Subprograms
Subprogram  Description 

"BUILD_CHAIN_ROWS_TABLE Procedure" 

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

"BUILD_EXCEPTIONS_TABLE Procedure" 

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


Go to previous page Go to next page
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback