Copyright Ó Oracle Corporation, 1999. All rights reserved.
9-16
Selecting Migrated Rows
SQL> ANALYZE
TABLE sales.order_hist LIST CHAINED ROWS;
Table
analyzed.
SQL>
SELECT owner_name, table_name,
head_rowid
2
FROM chained_rows
3
WHERE table_name = 'ORDER_HIST';
OWNER_NAME TABLE_NAME
HEAD_ROWID
---------- ----------
------------------
SALES ORDER_HIST AAAAluAAHAAAAA1AAA
SALES ORDER_HIST AAAAluAAHAAAAA1AAB
...