Re: EASY 'Q'.... How to you import falt text files into ORACLE8

Create control file and use sqlload command to load the data into database.

Example:
ATtUNIX prompt> sqlload userid=<username>/<password>@<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 - 10:05:14 CDT