http://blog.csdn.net/renfengjun/article/details/8284873
create table target_t (id number(4),namevarchar2(2000)) ;
create table source_t as select level as id ,'name' || level as name from dual connect by level <= 10004 ;
EXECUTE DBMS_ERRLOG.CREATE_ERROR_LOG(dml_table_name => 'target_t',err_log_table_name=> 'target_err_log') ;
desc target_err_log ;
insert into target_t select * from source_t LOGERRORS INTO target_err_log ('daily_load') REJECT LIMIT 4;
select * from target_err_log;
create table target_t (id number(4),namevarchar2(2000)) ;
create table source_t as select level as id ,'name' || level as name from dual connect by level <= 10004 ;
EXECUTE DBMS_ERRLOG.CREATE_ERROR_LOG(dml_table_name => 'target_t',err_log_table_name=> 'target_err_log') ;
desc target_err_log ;
insert into target_t select * from source_t LOGERRORS INTO target_err_log ('daily_load') REJECT LIMIT 4;
select * from target_err_log;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/720091/viewspace-1081014/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
临时表空间监控
请登录后发表评论
登录
全部评论
