Error while enabling database_tab_monitoring [message #409382] |
Mon, 22 June 2009 07:05 |
TRaj
Messages: 82 Registered: September 2006
|
Member |
|
|
Hi
I'm getting the below error while trying to execute the following commmnad,
SQL> exec DBMS_STATS.alter_database_tab_monitoring(TRUE);
The output of the cmd is,
Error starting at line 1 in command:
begin
DBMS_STATS.alter_database_tab_monitoring(TRUE);
end;
Error report:
ORA-25191: cannot reference overflow table of an index-organized table
ORA-06512: at "SYS.DBMS_STATS", line 10202
ORA-06512: at "SYS.DBMS_STATS", line 10226
ORA-06512: at line 2
25191. 00000 - "cannot reference overflow table of an index-organized table"
*Cause: An attempt to directly access the overflow table of an
index-organized table
*Action: Issue the statement against the parent index-organized table
containing the specified overflow table.
Is this a bug in 9i? How to solve this error.
Thanks in advance.
|
|
|
|
|