ERROR:
ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-30653: reject limit reached
创建外部表:
create or replace directory data_dir
as
'/u01/app/oracle/diag/rdbms/fuiou/fuiou/trace/'
/
create table alert_log
(
text_line varchar2(255)
)
organization external
(
type oracle_loader
default directory data_dir
access parameters
(
records delimited by newline
fields
)
location
(
'alert_fuiou.log'
)
)
/
alter table alert_log reject limit unlimited;
--告诉oracle, alert_log这个外部表行没有限制,如果不执行这条语句,下面查询的时候就会出以下错误:
ERROR:
ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-30653: reject limit reached
select to_char(last_time,'yyyy-mon-dd hh24:mi') shutdown,
to_char(start_time,'yyyy-mon-dd hh24:mi') startup,
round((start_time - last_time)*24*60,2) mins_down,
round((last_time - lag(start_time) over (order by R)),2) days_up,
case when (lead(R) over (order by R) is null)
then round((sysdate-start_time),2)
end days_still_up
from(
select R,
to_date(last_time, 'Dy Mon DD HH24:MI:SS YYYY') last_time,
to_date(start_time, 'Dy Mon DD HH24:MI:SS YYYY') start_time
from(
select R,
text_line,
lag(text_line,1) over (order by R) start_time,
lag(text_line,2) over (order by R) last_time
from(
select rownum r, text_line
from alert_log
where text_line like '___ ___ __ __:__:__ 20__'
or text_line like 'Starting ORACLE instance %'
)
)
where text_line like 'Starting ORACLE instance %'
)
/
查看警告日志
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26853563/viewspace-774324/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/26853563/viewspace-774324/