Re: Data File Not Found When Select External Tables

From: Resant <resant_v_at_yahoo.com>
Date: 6 Jun 2006 18:57:06 -0700
Message-ID: <1149645426.734751.297930@u72g2000cwu.googlegroups.com>

What do you mean create a table as a file? I do create a table to *map* to an existing file.
I create that file in \\server2\Data, and mapping to drive G.

Below is my script :

CREATE OR REPLACE DIRECTORY EXT_TABLES AS 'G:\EXT'; CREATE TABLE EXT_TABLES
(

      A       VARCHAR2(50 BYTE)  ,
      B       NUMBER              ,
      C       VARCHAR2(7 BYTE) ,
      D       VARCHAR2(10 BYTE),
      E       VARCHAR2(20 BYTE),
      F       DATE,
      )

  ORGANIZATION EXTERNAL
    (

      TYPE ORACLE_LOADER
      DEFAULT DIRECTORY EXT_TABLES
      ACCESS PARAMETERS


      (

        RECORDS DELIMITED BY NEWLINE
        FIELDS TERMINATED BY ','
        MISSING FIELD VALUES ARE NULL
(
                  A       ,
                  B       ,
                  C       ,
                  D       ,
                  E       ,
                  F       DATE "DD/MM/YYYY"
                  )
      )
      LOCATION ('data.csv')

    )
  REJECT LIMIT UNLIMITED; Thank you,

Resant Received on Tue Jun 06 2006 - 20:57:06 CDT