create table External Table (ORA9I) problem!

From: mawf <mawf_at_asiainfo.com>
Date: 24 Aug 2002 08:23:28 -0700
Message-ID: <6c5a24c8.0208240723.16cd153c@posting.google.com>

i have found a demo doc details as below: External Table Example
The following statement creates an external table that represents a subset
of the sample hr.employees table. The opaque_format_spec is shown in italics.
Please refer to Oracle9i Database Utilities for information on the ORACLE_LOADER
access driver and how to specify values for the opaque_format_spec.

CREATE TABLE emp_external (

   employee_id NUMBER(6),

   last_name      VARCHAR2(20),
   email          VARCHAR2(25),
   hire_date      DATE,
   job_id         VARCHAR2(10),
   salary         NUMBER(8,2)

)

ORGANIZATION EXTERNAL
(TYPE oracle_loader
 DEFAULT DIRECTORY admin
 ACCESS PARAMETERS
 (
  RECORDS DELIMITED BY newline
  BADFILE 'ulcase1.bad'
  DISCARDFILE 'ulcase1.dis'
  LOGFILE 'ulcase1.log'
  SKIP 20
  FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"'   (

   deptno     INTEGER EXTERNAL,
   dname      CHAR,
   loc        CHAR

  )
 )
 LOCATION ('ulcase1.dat')
)

REJECT LIMIT UNLIMITED;

---

when i run the script , it pops a error msg just like 'cound not found DEFAULT DIRECTORY admin',so why ? and i am confused for those below:
  (

   deptno     INTEGER EXTERNAL,
   dname      CHAR,
   loc        CHAR

  )
what does this mean ?

thanks a lot! Received on Sat Aug 24 2002 - 10:23:28 CDT