Re: newbie question - importing txt file to Oracle

In article <95rniv$evu$1_at_nnrp1.deja.com>,   dmalto_at_mail.ru wrote:
> Hi,
> For TAB delimited control file for SQL Loader should be something like
> this:
>
> LOAD DATA
> INFILE 'file.txt'
> INTO TABLE s.tab1
> FIELDS TERMINATED BY X'09' TRAILING NULLCOLS
> (col1, col2, col3)
>
> If you performing migration task I can offer you a tool that converts
> data from any database to a text file, creates CREATE TABLE scripts and
> control file for Oracle SQL Loader
> You should only run generated script. It does all work you need.
>
> http://www.ispirer.com/chyfo.html
>
> --
> Best regards, Dmitry
>
> In article <95qkd7$jej$1_at_nnrp1.deja.com>,
> illiken_at_my-deja.com wrote:
> > I have a tab delimited file which I need to import into Oracle 8.1.5.,
> > what is the easiest way to do this?
> > Any suggestions would be wonderful.
> >
> > Thanks in advance
> >
> > illiken
> >
> > Sent via Deja.com
> > http://www.deja.com/
> >
>
> Sent via Deja.com
> http://www.deja.com/
>
thanks for the help

illiken

Sent via Deja.com
http://www.deja.com/ Received on Wed Feb 07 2001 - 17:10:44 CET