Home » RDBMS Server » Server Administration » Error while enabling database_tab_monitoring (9i R2 9.2.0.1.0 on Windows XP 32 bit)  () 1 Vote
Error while enabling database_tab_monitoring [message #409382] Mon, 22 June 2009 07:05 Go to next message
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.
Re: Error while enabling database_tab_monitoring [message #409388 is a reply to message #409382] Mon, 22 June 2009 07:31 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
You cannot use alter_database_tab_monitoring, you have to use ALTER_SCHEMA_TAB_MONITORING and even alter table for the schema owning iot with overflow.

Regards
Michel
Re: Error while enabling database_tab_monitoring [message #409412 is a reply to message #409388] Mon, 22 June 2009 08:28 Go to previous message
TRaj
Messages: 82
Registered: September 2006
Member

Thanks Michel.
Previous Topic: How to know who lock the Account ?
Next Topic: ORACLE DBA (merged)
Goto Forum:
  


Current Time: Sun Dec 01 17:16:52 CST 2024