dbms_errlog.create_error_log

dbms_errlog.create_error_log
(  
   dml_table_name          -- in varchar2
   err_log_table_name      -- in varchar2  未指定时:err$_tablename
   err_log_table_owner     -- in varchar2  
   err_log_table_space     -- in varchar2
   skip_unsupported        -- in boolean :=false 
)
--不支持 long、clob、blob、bfile
log errors [into err_log_table_name[(tag)] reject limit unlimited | n(0)  n为整数常量值]

err_log_numbers=n+1

在forall中
sql%rowcount、sql%bulk_exceptions.count 、log errors reject limit 均是累加

errlog行级
save exceptions 语句级
UPDATE TB_ADS_IB_COMMON a SET ( a.SYSTEM_ID, a.UCM_ID_C, a.SERVICE_PL, a.SITE_PROVINCE, a.FE_CHANNEL, a.FE_REGION, a.ASSET_NUM, a.REGION, a.ACCOUNT_SEGMENT_LEVEL, a.INSTALLED_AT_ALTERNATE_CUSTOMER_NAME, a.MODALITY, a.DI_US_LCS, a.RGM, a.RGM_SSO, a.ZONE_MANAGER, a.ZONE_MANAGER_SSO, a.SVC_SALES, a.SALES_SSO, a.HEAD_SSO, a.HEAD_NAME, a.ZOM_SSO, a.ZOM_NAME, a.PSI_DESC, a.CN_2ND_LEVEL_MODALITY, a.SERIAL_NUM, a.PSI_CODE_NEW, a.PART_NUM_DESC, a.INSTAL_DT, a.WARRANTY_END_DT, a.SERVICE_REGION, a.INSTALLED_AT_CUSTOMER_NBR, a.SITE_ID, a.CFDA_NAME, a.KEY_PRODUCT, a.LST_UPD_DT, a.STATUS, a.ACCOUNT_SEGMENT_2ND_LEVEL, a.INST_ADDRLINE3, a.ASSET_STATUS, a.COMMERCIAL_C_START, a.COMMERCIAL_C_END, a.SITE_CITY, a.ENTERPRISE, a.EQ_SEGMENT, a.FE_NAME, a.FE_SSO, a.IB_TYPE, a.MOD_1, a.PRODUCT_SEGMENT, a.PSI_CD, a.WARRANTY_START_DT_OVERRIDE, a.ZONE, a.PO_NUMBER, a.FAMILY_NAME, a.SERVICEABLE_IB, a.SERIES_2, a.CONVT_RENEW_OPP_NEW, a.TUBE_M, a.SALES_ORDER_NUM, a.TERRITORY_2, a.UPDATE_TIME ) = ( SELECT c.SYSTEM_ID, c.UCM_ID_C, c.SERVICE_PL, c.SITE_PROVINCE, c.FE_CHANNEL, c.FE_REGION, c.ASSET_NUM, c.REGION, c.ACCOUNT_SEGMENT_LEVEL, c.INSTALLED_AT_ALTERNATE_CUSTOMER_NAME, c.MODALITY, c.DI_US_LCS, c.RGM, c.RGM_SSO, c.ZONE_MANAGER, c.ZONE_MANAGER_SSO, c.SVC_SALES, c.SALES_SSO, c.HEAD_SSO, c.HEAD_NAME, c.ZOM_SSO, c.ZOM_NAME, c.PSI_DESC, c.CN_2ND_LEVEL_MODALITY, c.SERIAL_NUM, c.PSI_CODE_NEW, c.PART_NUM_DESC, c.INSTAL_DT, c.WARRANTY_END_DT, c.SERVICE_REGION, c.INSTALLED_AT_CUSTOMER_NBR, c.SITE_ID, c.CFDA_NAME, c.KEY_PRODUCT, c.LST_UPD_DT, c.STATUS, c.ACCOUNT_SEGMENT_2ND_LEVEL, c.INST_ADDRLINE3, c.ASSET_STATUS, c.COMMERCIAL_C_START, c.COMMERCIAL_C_END, c.SITE_CITY, c.ENTERPRISE, c.EQ_SEGMENT, c.FE_NAME, c.FE_SSO, c.IB_TYPE, c.MOD_1, c.PRODUCT_SEGMENT, c.PSI_CD, c.WARRANTY_START_DT_OVERRIDE, c.ZONE, c.PO_NUMBER, c.FAMILY_NAME, c.SERVICEABLE_IB, c.SERIES_2, c.CONVT_RENEW_OPP_NEW, c.TUBE_M, c.SALES_ORDER_NUM, c.TERRITORY_2, c.UPDATE_TIME FROM TB_ADS_IB_COMMON_INCREMENTAL_BAK c WHERE a.asset_num = c.asset_num AND c.delete_flag = 0 AND ROWNUM <![CDATA[<= ]]> 1 ) WHERE EXISTS ( SELECT 1 FROM TB_ADS_IB_COMMON_INCREMENTAL_BAK c WHERE a.asset_num = c.asset_num AND c.delete_flag = 0 ) 需要返回更新数量, oracle, 不能写存储过程, 现在数据量大很慢, 怎么优化一下
最新发布
11-06
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值