error 信息

Errors in file /oracle/app/oracle/admin/prd/bdump/prd_j000_688158.trc:
ORA-12012: error on auto execute of job 8897
ORA-20000: ORA-20000: Content of the tablespace specified is not permanent or ta
blespace name is invalid
ORA-06512: at "SYS.PRVT_ADVISOR", line 1624
ORA-06512: at "SYS.DBMS_ADVISOR", line 186
ORA-06512: at "SYS.DBMS_SPACE", line 1344
ORA-06512: at "SYS.DBMS_SPACE", line 1560

The issue was noticed because of repeated occurence of the following error in the alert log.
Mon Nov 7 22:00:25 2005
ORA-12012: error on auto execute of job 76357
ORA-20000: ORA-20000: Content of the tablespace specified is not permanent or
tablespace name is invalid
ORA-06512: at "SYS.PRVT_ADVISOR", line 1624
ORA-06512: at "SYS.DBMS_ADVISOR", line 186
ORA-06512: at "SYS.DBMS_SPACE", line 1338
ORA-06512: at "SYS.DBMS_SPACE", line 1554


Cause

The problem is when the tablespace is created the statistics are captured for this tablespace. When the tablespace is
dropped the segments for which the segstats are collected continue to reference the dropped tablespace.

The AUTO_SPACE_ADVISOR_JOB does not find the tablespace and returns the error.

To duplicate the error from the sql command line:

Direct test in SQL*Plus:
SQL> connect sys/manager as sysdba
Connected.
SQL> exec dbms_space.auto_space_advisor_job_proc
BEGIN dbms_space.auto_space_advisor_job_proc; END;
*
ERROR at line 1:
ORA-20000: Content of the tablespace specified is not permanent or tablespace
name is invalid
ORA-6512: at "SYS.PRVT_ADVISOR", line 1624
ORA-6512: at "SYS.DBMS_ADVISOR", line 186
ORA-6512: at "SYS.DBMS_SPACE", line 1338
ORA-6512: at "SYS.DBMS_SPACE", line 1554
ORA-6512: at line 1

Internal BUG:4707226 - Appsst Srv 10g : Auto_Space_Advisor_Job Failed With Ora-2000