Re: importing text data files

use the import utility. this is usually located in the %ORACLE_HOME%\bin directory (imp.exe). you will need to create a control file to explain to the utility where the fields are, etc...

an example of what one would look like is this:

LOAD DATA
INFILE 'MYFILE.SDF'
BADFILE 'MYFILE.BAD'
DISCARDFILE 'MYFILE.DSC'
INTO TABLE MYTABLE

    (MENUMBER             POSITION(   1:  10) CHAR,
     PRODCODE             POSITION(  11:  15) CHAR,
     PLANCODE             POSITION(  16:  21) CHAR,
     RECNO  RECNUM)

"Praveen" <seemapraveen_at_worldnet.att.net> wrote in message news:<9sre3k$cip$1_at_bob.news.rcn.net>...
> Hello,
> I am trying to import text files (comma delimited) into Oracle 8i.
> Could anyone tell me how this is done? I really appreciate any help. Thank
> you!!
>
> -Seema
Received on Tue Nov 13 2001 - 23:09:37 CET