December 2002
Intermediate to advanced
928 pages
85h 29m
English
PROCEDURE DBMS_IOT.BUILD_CHAIN_ROWS_TABLE
(owner IN VARCHAR2,
iot_name IN VARCHAR2.
chainrow_table_name IN VARCHAR2 DEFAULT 'IOT_CHAINED_ROWS');
Builds table chainrow_table_name to hold references to chained rows in iot_name owned by owner.
PROCEDURE DBMS_IOT.BUILD_EXCEPTIONS_TABLE
(owner IN VARCHAR2,
iot_name IN VARCHAR2.
exceptions_table_name IN VARCHAR2 DEFAULT 'IOT_EXCEPTIONS_ROWS');
Builds table exceptions_table_name to hold rows of iot_name table owned by owner which violate constraints.