Re: ORA9i (on HP-UX 11.0) create external table problem!

Hi,

You need to create the admin directory:

SQL> create directory testdir as ‘/u01/oracle/oradata/mysid';  

Directory Created.

Hope this helps . . .

Donald Burleson

mawf_at_asiainfo.com (mawf) wrote in message news:<6c5a24c8.0208241757.592fa47e_at_posting.google.com>...
> 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 Sun Aug 25 2002 - 14:24:27 CDT