- 论坛徽章:
- 0
|
入库文件内容为alert告警信息:
Mon Apr 28 01:06:29 EAT 2014
ORA-1653: unable to extend table scott.test by 128 in tablespace ttttt
Mon Apr 28 05:16:02 EAT 2014
Errors in file /oracle10/app/oracle/admin/odsb1/bdump/odsb11_j002_7201.trc:
ORA-12012: error on auto execute of job 331492
ORA-04021: timeout occurred while waiting to lock object
Mon Apr 28 09:25:02 EAT 2014
WARNING: inbound connection timed out (ORA-3136)
入库表:
create table TMP_ORA_ALERT
(
CONTEXT VARCHAR2(2000),
ID NUMBER(10)
);
网上查询到 使用 str属性,没能解决
④使用str属性
可使用str来定义一个行结尾符
计算以|\r\n 结束的值:
select utl_raw.cast_to_raw('|'||chr(13)||chr(10)) from dual;
结果 7C0D0A
|
|