i have found a external table create demo in ora9i doc as below shows:
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;
now the problem is ,when i run the script ,it will pops a err msg just like:
'counld not found directory admin' in DEFAULT DIRECTORY parameter setup,
i looked up the details for the parameter, but nothing can help me
,
and another question is ,what does this meam which shows as below in script:
(
deptno INTEGER EXTERNAL,
dname CHAR,
loc CHAR
)
so ,any suggestion will be appreciated.
Received on Sat Aug 24 2002 - 20:57:55 CDT
