Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: how to import text file (.txt) into existing Oracle table and automate the process

Re: how to import text file (.txt) into existing Oracle table and automate the process

From: Jim Kennedy <kennedy-family_at_attbi.com>
Date: Sun, 26 May 2002 19:21:09 GMT
Message-ID: <FAaI8.87660$L76.141370@rwcrnsc53>


Look in the docs under Oracle utilities for sql loader. Jim
<whitsmore> wrote in message
news:tkc2fu8t5air48hg3s6pna8t54v5pprn6p_at_4ax.com...
> I have a text file called test.txt . I want to import this into an
> existing Oracle 9i table (NT version). The text file basically has 12
> fields, but the Oracle table has 13 since the first field is a primary
> key that uses a sequence and a trigger to autogenerate a number. Can
> I do what I'm describing? Is so, how? Thx
Received on Sun May 26 2002 - 14:21:09 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US