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

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 Received on Wed Mar 23 2005 - 20:28:04 CST