Re: Question: Importing fixed width text files into Oracle8 under linux

Use SQL*Loader (it is described in the Oracle7/8 Server Utilities Manual). It is a much older product than Intelligent Agent, and you won't need OIA for running Sql*Loader. Just your own brains to setup a control file. And then of course you could use Bill's Open DataBase Creativity through Access or Excel to accomplish the same. That might even be easier, but not as flexible.

Hth,

Sybrand Bakker, Oracle DBA

mark <mark_at_cybertrails.com> wrote in message news:3778F208.65A5EA54_at_cybertrails.com...
> Once a month I need to import data into my Oracle8 database, the data
> comes in a fixed width text file. How can I put that data into a new
> table from the text file? Is there a way to do it without using
> Enterprise Manager? Since, I have not been able to get the intelligent
> agent to work.
>
>
> Mark Wagner
> New DBA....
> mark_at_cybertrails.com
>
>
>
Received on Tue Jun 29 1999 - 13:12:31 CDT