Re: Loading data into a table from the file

lanclosd_at_bcstec.ca.boeing.com (Dwayne K. Lanclos) writes:

>Semyon Basin (sb63_at_namaste.cc.columbia.edu) wrote:
>> I have a newbie question.
>> Since I do not know where the FAQ is, could you please help me.
>> How do I load data into a table directly from a disk file?
>> I know a little bit of INGRES and they have something like this:
>> COPY table FROM 'disk_file';
>> Thanx in advance.
 

>I would use SQL*Loader. You build a little script file that tells it
>what your fields are and in which columns of the file they begin. Oracle
>does the rest.

I actually just used the 'ascprep' utility which utilizes SQL*loader and actually writes the script (control file) for you. Syntax is as follows.

ascprep -t(tablename) scott/tiger a:(filename.csv)

   Ascprep will run through some questions re date formatting and I'm using a comma-separated file.

jirwin_at_lancelot.colorado.edu

-- 
                            ,,,,
                           /_  _\
                      ooo ( O  O ) ooo
~~~~~~~~~~~~~~~~~~~~~~(((~~~~~~~~~~)))~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~