Databases Reference
In-Depth Information
10. Create table
CHAINED_ROWS
:
create table HR.CHAINED_ROWS (
owner_name varchar2(30),
table_name varchar2(30),
cluster_name varchar2(30),
partition_name varchar2(30),
subpartition_name varchar2(30),
head_rowid rowid,
analyze_timestamp date
);
11. Analyze the table to list the migrated rows:
ANALYZE TABLE HR.BIG_ROWS LIST CHAINED ROWS
INTO HR.CHAINED_ROWS;
12. Count (or list) the migrated rows:
SELECT COUNT(*) FROM HR.CHAINED_ROWS;
13. In the next screenshot, we can see the results of these operations:
