Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_IOT, 2 of 3
The 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.
DBMS_IOT.BUILD_CHAIN_ROWS_TABLE ( owner IN VARCHAR2, iot_name IN VARCHAR2, chainrow_table_name IN VARCHAR2 default 'IOT_CHAINED_ROWS');
Parameter | Description |
---|---|
owner |
Owner of the index-organized table. |
iot_name |
Index-organized table name. |
chainrow_table_name |
Intended name for the chained-rows table. |
CREATE TABLE l(a char(16),b char(16), c char(16), d char(240), PRIMARY KEY(a,b,c)) ORGANIZATION INDEX pctthreshold 10 overflow; EXECUTE DBMS_IOT.BUILD_CHAIN_ROWS_TABLE('SYS','L','LC');
A chained-row table is created with the following columns:
Column Name Null? Type ------------------------------ -------- ---- OWNER_NAME VARCHAR2(30) TABLE_NAME VARCHAR2(30) CLUSTER_NAME VARCHAR2(30) PARTITION_NAME VARCHAR2(30) SUBPARTITION_NAME VARCHAR2(30) HEAD_ROWID ROWID TIMESTAMP DATE A CHAR(16) B CHAR(16) C CHAR(16)
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|