External Tables binding to Access?

[gajaya1@netscape.net]

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_population s_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_populatio ns.log'
BADFILE census_data:
'city_populatio ns.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_populati ons.dat')
)
PARALLEL 4 REJECT LIMIT UNLIMITED;

[FaheemRao]

Re: External Tables binding to Access?

Oracle provides a tool called Oracel Migration Assistance . Throught
this tool you can get Access Data in Oracle.



Faheem

gajaya1@netscap e.net wrote in message news:<ef6582c0. 0312121322.8970 36e@posting.goo gle.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_population s_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_populatio ns.log'
BADFILE census_data:
'city_populatio ns.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_populati ons.dat')
)
PARALLEL 4 REJECT LIMIT UNLIMITED;