job 8888

Sat Dec 23 12:00:03 2006
Errors in file /orabase/oracle/admin/wlapp/bdump/wlapp_j000_512054.trc:
ORA-12012: error on auto execute of job 8888
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
看了两个帖子 http://spaces.msn.com/members/oradoc/
http://chamberszheng.blogspot.com
都不能解决问题，统计的表空间和存在的表空间是一样的

sQL> select distinct tablespace_name from DBA_AUTO_SEGADV_CTL;

TABLESPACE_NAME
------------------------------
SYSAUX
TRIANGLE
SJINDEX

SQL> select tablespace_name from dba_tablespaces;

TABLESPACE_NAME
------------------------------
SYSTEM
UNDOTBS1
SYSAUX
TEMP
USERS
WLXT
WLTHXT
LNSTS
TRIANGLE
INDEXS
SJINDEX
有没有高手能解决呢？

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/8135069/viewspace-136019/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/8135069/viewspace-136019/