Oracle Database Discussions

Hello,

Yesterday i did a couple of manual stats gathering using the commands

dbms_stats.gather_table_stats('DATALOAD','CAMPAIGN_SELECTION',cascade=>TRUE);
dbms_stats.gather_table_stats('DATALOAD','CAMPAIGN',cascade=>TRUE);

which worked fine but when i try and do them again i get the message

ORA-20905: ORA-20905: Not allowed to drop system tables.

This caused me to look in the alert log and i found an error message pointing me in the direction of this little fella:


Dump file c:\oracle\product\10.2.0\admin\hill\bdump\hill_j001_4908.trc
Thu Feb 16 22:13:12 2012
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Release 10.2.0.1.0 - Production
Windows Server 2003 Version V5.2 Service Pack 2
CPU : 4 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:2109M/4095M, Ph+PgF:6782M/8533M, VA:1629M/2047M
Instance name: hill

Redo thread mounted by this instance: 1

Oracle process number: 20

Windows thread id: 4908, image: ORACLE.EXE (J001)


*** 2012-02-16 22:13:12.074
*** ACTION NAME:(GATHER_STATS_JOB) 2012-02-16 22:13:12.074
*** MODULE NAME:(DBMS_SCHEDULER) 2012-02-16 22:13:12.074
*** SERVICE NAME:(SYS$USERS) 2012-02-16 22:13:12.074
*** SESSION ID:(132.23208) 2012-02-16 22:13:12.074
ORA-20905: Not allowed to drop system tables
*** 2012-02-16 22:13:12.074
GATHER_STATS_JOB: GATHER_TABLE_STATS('"DATALOAD"','"ESHOT_DATA_MATCHING"','""', ...)
ORA-20905: Not allowed to drop system tables
*** 2012-02-16 22:13:16.793
GATHER_STATS_JOB: GATHER_TABLE_STATS('"TEMPLOAD"','"TEMP_CAMPAIGN_MANAGER"','""', ...)
ORA-20905: Not allowed to drop system tables
*** 2012-02-16 22:13:22.137
GATHER_STATS_JOB: GATHER_TABLE_STATS('"SYS"','"OBJ$"','""', ...)
ORA-20905: Not allowed to drop system tables
*** 2012-02-16 22:14:06.309
GATHER_STATS_JOB: GATHER_TABLE_STATS('"SYS"','"WRH$_SYSSTAT"','""', ...)
ORA-20905: Not allowed to drop system tables
*** 2012-02-16 22:14:08.606
GATHER_STATS_JOB: GATHER_TABLE_STATS('"SYS"','"WRH$_PARAMETER"','""', ...)
ORA-20905: Not allowed to drop system tables
*** 2012-02-16 22:14:11.122
GATHER_STATS_JOB: GATHER_TABLE_STATS('"SYS"','"WRH$_SYSMETRIC_SUMMARY"','""', ...)
ORA-20905: Not allowed to drop system tables
*** 2012-02-16 22:14:14.200
GATHER_STATS_JOB: GATHER_TABLE_STATS('"SYS"','"WRH$_LATCH"','""', ...)
ORA-20905: Not allowed to drop system tables
*** 2012-02-16 22:14:27.231
GATHER_STATS_JOB: GATHER_TABLE_STATS('"SYS"','"WRH$_ACTIVE_SESSION_HISTORY"','""', ...)
ORA-20905: Not allowed to drop system tables
*** 2012-02-16 22:14:30.294
GATHER_STATS_JOB: GATHER_TABLE_STATS('"SYS"','"HISTGRM$"','""', ...)
ORA-20905: Not allowed to drop system tables
*** 2012-02-16 22:14:56.106
ORA-12012: error on auto execute of job 8886
ORA-20905: ORA-20905: Not allowed to drop system tables
ORA-06512: at line 5
ORA-06512: at "SYS.DBMS_STATS_INTERNAL", line 562
ORA-06512: at "SYS.DBMS_STATS", line 18573
ORA-06512: at "SYS.DBMS_STATS", line 18966

Does anyone have any ideas? :)

Let me know if you need further information.

Cheers,

Dan.