Create Table with clause Organization External

[Bigcat37]

Hi

for 9i i've write a plsql function reading the alert file from my bdump
directory using create table with clause Organization External. It's ok
and it works very well.

Is it possible to to the same things for 8.1.7 and what is the syntax.
actually i've an error.
===========
= Syntax 9i =
===========
CREATE TABLE ALERTLOGTEMP
(
LINE VARCHAR2(4000 BYTE)
)
ORGANIZATION EXTERNAL
( TYPE ORACLE_LOADER
DEFAULT DIRECTORY BACKGROUND_DUMP_DEST_DIR
ACCESS PARAMETERS
( records delimited BY newline nobadfile nologfile
nodiscardfile fields terminated BY '#$~=ui$X' missing field
VALUES are NULL (line) )
LOCATION (BACKGROUND_DUMP_DEST_DIR:'alert_FSV.log')
)
REJECT LIMIT UNLIMITED
NOPARALLEL
NOMONITORING;

Regards
Denis

 

[SantaMufasa]

Sorry, Denis, "ORGANIZATION EXTERNAL" is an Oracle 9i enhancement.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]