External Tables binding to Access?

From: <gajaya1_at_netscape.net>
Date: 12 Dec 2003 13:22:29 -0800
Message-ID: <ef6582c0.0312121322.897036e_at_posting.google.com>


I only find information connecting Oracle external tables to data files. But I dont want to transfer data to files instead I want directly transfer data to oracle from Access. I do not know how to change the syntax of the below External table binding

CREATE TABLE city_populations_ext (

   city_name VARCHAR(9),
   pop_1990 NUMBER,
   pop_2000 NUMBER
)

ORGANIZATION EXTERNAL (
   TYPE oracle_loader
   DEFAULT DIRECTORY census_data
   ACCESS PARAMETERS (

      RECORDS FIXED 20
      LOGFILE census_data:
        'city_populations.log'
      BADFILE census_data:
        'city_populations.bad'
      FIELDS
      MISSING FIELD VALUES ARE NULL (
          city_name (1:10) CHAR(9),
          pop_1990  (11:15) INTEGER 
        EXTERNAL(4),
          POP_2000  (16:20) INTEGER 
        EXTERNAL(4)
          )

   )
   LOCATION ('city_populations.dat')
)

PARALLEL 4 REJECT LIMIT UNLIMITED; Received on Fri Dec 12 2003 - 22:22:29 CET

Original text of this message