create directory BDUMP as 'D:\ORACLE\admin\ORCL\bdump';

create table alert_log
(
   detail_line VARCHAR2(2000)
)
ORGANIZATION EXTERNAL
(
  TYPE oracle_loader
  DEFAULT DIRECTORY BDUMP
  ACCESS PARAMETERS
  (
    RECORDS DELIMITED BY NEWLINE
    nobadfile
    nologfile
    nodiscardfile
    FIELDS TERMINATED by ' '
    MISSING FIELD VALUES ARE NULL
    (detail_line)
  )
  LOCATION('alert_SIVDB.log')
 )
  parallel 5
  REJECT LIMIT UNLIMITED;