"Ron" <support_at_dbainfopower.com> wrote in message
news:qYSdnVX9i89EHbHdRVn-hg_at_comcast.com...
>
> Here you go:
>
> 1. create directory BDUMP as '...';
>
> 2. create table alert_log ( text varchar2(80) )
> organization external (
> type oracle_loader
> default directory BDUMP
> access parameters (
> records delimited by newline
> )
> location('<alert.log>')
> )
> reject limit 1000;
How long is a line in an alert.log? Why do you allow 1000 rejects?
--
Niall Litchfield
Oracle DBA
Audit Commission UK
Received on Fri Feb 13 2004 - 03:35:17 CST
