By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,180 Members | 1,012 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,180 IT Pros & Developers. It's quick & easy.

External Tables binding to Access?

P: n/a
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;
Jul 19 '05 #1
Share this Question
Share on Google+
1 Reply


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

Faheem

ga*****@netscape.net wrote in message news:<ef*************************@posting.google.c om>...
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;

Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.