: Just found aout another reason for this problem, the chain rows table might : be created incorrectly, in other words incompatible with your Oracle : version. : If you run Oracle 8.0 please run the following script : DROP TABLE ORA_MONITOR.CHAINED_ROWS; : CREATE TABLE ORA_MONITOR.CHAINED_ROWS ( : OWNER_NAME VARCHAR2(30), : TABLE_NAME VARCHAR2(30), : CLUSTER_NAME VARCHAR2(30), : PARTITION_NAME VARCHAR2(30), : HEAD_ROWID ROWID, : ANALYZE_TIMESTAMP DATE : ); : If you run Oracle 8i please run the following script : DROP TABLE ORA_MONITOR.CHAINED_ROWS; : CREATE TABLE ORA_MONITOR.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 : ); : After that the Table Analyzer in DB Monitor should work correctly. Thanks a lot, I was create the table in oracle 8i and DB Monitor works correctly, if I migrate to Oracle 9i, this tools work in this enviroment. Thanks a lot again!! Israel
|