Re: howto ANALYZE index organized table to find chained row(overflow)

dominica_at_gmail.com wrote:

> Hi All,
>
> I actually DID it:
>
> The actually steps:
>
>
> 1) login as SYS
> 2) @dbmsiotc.sql
>
> 3) execute
> dbms_iot.build_chain_rows_table('aa2','orders_iot','DOM_orders_iot_CHAIN');
>
> 4)
> analyze table aa2.orders_iot list chained rows into
> aa2.dom_orders_iot_chain;
>
> 5) If there is CHAINED ROW, that mean overthrow, then the following
> table won't be empty. Since count(*) is zero, you have no chained row.
>
>
> SQL> select count(*) from aa2.dom_orders_iot_chain;
>
> COUNT(*)
> ----------
> 0

A full demo of this is on the PSOUG web site in the library.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)