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
有没有高手能解决呢?
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/