建外部表查看报警日志错误

一目标：建外部表查看报警日志错误

 

注意环节：执行alter table alert_log reject limit unlimited;

否则报错。    

ora-29913

ora-30653 

 

二具体操作过程：

createdirectory bdump_alert as '/opt/app/oracle/diag/rdbms/sun/sun_1/trace';

createtable alert_log(

textvarchar2(400)

)organizationexternal

(typeoracle_loader

defaultdirectory bdump_alert

accessparameters

(recordsdelimited by newline

)location('alert_sun_1.log')

); 

 

 

三操作

select *from alert_log;

 

报错

ora-29913

ora-30653

 

执行

 

altertable alert_log reject limit unlimited;

 

再次执行

select *from alert_log;

正常显示