job 8888
上一篇 /
下一篇 2007-01-29 09:53:49
查看( 130 ) /
评论( 2 )
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
有没有高手能解决呢？
论坛模式
推荐
收藏
分享给好友
推荐到圈子
管理
TAG:
-
fangjinde发布于2007-01-29 09:58:31
-
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
为什么要加 " SYS. ",把这个去掉试试
-
lijiebin
发布于2007-01-29 10:07:17
-
QUOTE:
最初由 fangjinde 发布
[B]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
为什么要加 " SYS. ",把这个去掉试试 [/B]
哥们。我不是开发人员，呵呵，你的意思是这个错误的产生是因为开发的问题吗？ 开发人员他们说是自己从没写过SYS.PRVT_ADVISOR这个参数，我怎么能把这个参数找出来去个他们对峙呢
