Re: newbie question - importing txt file to Oracle

Hi,
[Quoted] 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/