alter table ... nomonitoring doesn't work??

Giganews Newsgroups
Subject: alter table ... nomonitoring doesn't work??
Posted by:  Ben (balv…@comcast.net)
Date: Wed, 25 Jul 2007

10.2.0.2 EntEd, AIX5L

I had several tables set to nomonitoring in 9.2.0.5 now that I
upgraded to 10.2.0.2, it turned monitoring on for all tables and I
can't get it to turn off. Anyone else have this issue?

SQL> alter table proddta.f3411 nomonitoring;

Table altered.

SQL> select owner, table_name, monitoring
  2  from dba_tables
  3  where owner = 'PRODDTA'
  4  and table_name = 'F3411';

OWNER                          TABLE_NAME                    MON
------------------------------ ------------------------------ ---
PRODDTA                        F3411                          YES

SQL> begin
  2  dbms_stats.unlock_table_stats(
  3  ownname  => 'PRODDTA',
  4  tabname  => 'F3411');
  5  end;
  6  /

PL/SQL procedure successfully completed.

SQL> alter table proddta.f3411 nomonitoring;

Table altered.

SQL> select owner, table_name, monitoring
  2  from dba_tables
  3  where owner = 'PRODDTA'
  4  and table_name = 'F3411';

OWNER                          TABLE_NAME                    MON
------------------------------ ------------------------------ ---
PRODDTA                        F3411                          YES

SQL>

Replies