When I attempt to execute the analysis portion of the Repair Chained Rows wizard, I received the "ORA-01496: specified chain row table form incorrect" error, with the option to continue or stop. I am trying to analyze tables which inlcude index-organized tables.
Toad creates the CHAINED_ROWS table as follows:
create table 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
);
In order to analyze index-organized tables the following table is required
create table CHAINED_ROWS (
owner_name varchar2(30),
table_name varchar2(30),
cluster_name varchar2(30),
partition_name varchar2(30),
subpartition_name varchar2(30),
head_rowid urowid,
analyze_timestamp date
);
Toad should be creating the table with UROWID to cater for both physical and logical rowids (as in index-organized tables)
WORKAROUND
Drop the existing CHAINED_ROWS table and recreate the table as follows.
create table 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
);
STATUS
Waiting for fix in a future release of Toad for Oracle
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center