alert_log設定成external table

SQL> create or replace
  2  directory alert_dir
  3  as
  4  'E:\oracle\product\10.2.0\admin\bruce\bdump';

Directory created.

SQL> edit
Wrote file afiedt.buf
  1  create table alert_log
  2  (text_line varchar2(255))
  3  organization external
  4  (type oracle_loader default directory alert_dir
  5   access parameters
  6   (records delimited by newline
  7    fields
  8   )
  9   location
 10   (
 11   'alert_bruce.log'
 12   )
 13* )
SQL> /


Table created.