Re: EASY 'Q'.... How to you import falt text files into ORACLE8
From: sirirut vanichayobon <svanicha_at_cs.ou.edu>
Date: Fri, 11 Jun 1999 10:05:14 -0500
Message-ID: <376125AA.7FD66303_at_cs.ou.edu>
Date: Fri, 11 Jun 1999 10:05:14 -0500
Message-ID: <376125AA.7FD66303_at_cs.ou.edu>
Create control file and use sqlload command to load the data into database.
Example:
ATtUNIX prompt> sqlload userid=<username>/<password>_at_<SID>
control=<control file> bad=<bad file> log=<log file>
Example of control file:
load data
infile 'data.dat"
discardmax 999
-- append
insert
into table TABLE_TEST
fields terminated by ',' optionally enclosed by "'"
trailing nullcols
(NAME,
DATE_TIME,
)
Clarence Hart Jr. wrote:
> This is an ultra easy Q... How do you import flat text (comma delim.)
> files into Oracle8 for UNIX.
>
> I use SYBASE and bcp is the utility I usually use.
> Does Oracle have such a tool!!
>
> Thanks!!
>
> Clarence
Received on Fri Jun 11 1999 - 17:05:14 CEST