Re: SQL*Load Questions

Chris,

Does it have to be SQL*Load? There is a facility in Data Manager for loading data into tables, you just tell it where your data file and control files are. With regard to writing control files the basic ones are, well, basic :-)

Eg

load data
infile 'c:\oracledata\t1_data'
into table demo.t1
fields terminated by ' ' <---- tab character in quotes (col1,
 col2,
 col3)

This will load data into table t1 from the datafile t1_data.dat. You don't need the .dat extension in Data Manager. I find this does pretty much what is required if you are just populating tables.

HTH P. Received on Fri Feb 19 1999 - 03:19:07 CST