Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_IOT, 3 of 3
The 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.
A separate chained-rows table and an exception table should be created for each index-organized table to accommodate its primary key.
DBMS_IOT.BUILD_EXCEPTIONS_TABLE ( owner IN VARCHAR2, iot_name IN VARCHAR2, exceptions_table_name IN VARCHAR2 default 'IOT_EXCEPTIONS');
Parameter | Description |
---|---|
owner |
Owner of the index-organized table. |
iot_name |
Index-organized table name. |
exceptions_table_name |
Intended name for exception-table. |
EXECUTE DBMS_IOT.BUILD_EXCEPTIONS_TABLE('SYS','L','LE');
An exception table for the above index-organized table with the following columns:
Column Name Null? Type ------------------------------ -------- ---- ROW_ID VARCHAR2(30) OWNER VARCHAR2(30) TABLE_NAME VARCHAR2(30) CONSTRAINT VARCHAR2(30) A CHAR(16) B CHAR(16) C CHAR(16)
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|