Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: how to import text file (.txt) into existing Oracle table and automate the process
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