Re: converting flat files to oracle tables or unix

From: STiger2000 <stiger2000_at_my-deja.com>
Date: Fri, 06 Oct 2000 21:51:58 GMT
Message-ID: <8rlhhr$usg$1@nnrp1.deja.com>

With a little shell code, maybe some perl, and then calling sqlplus ... sort of ...
the tool of choice for this type of operation would be SQL Loader. It is specifically desgined to take flat files and use them to populate a table in an Oracle database. We have done this to capture system stats and build a database repository for analysis. Works great, the code was a 'work for hire' project, so we can't share it here ... but the concept is pretty straight forward.
jc
http://www.networkessentials.com/certified/ocp

In article <stmtpgd2bvgd4_at_corp.supernews.com>, KELVIN <kelvinnegron_at_hotmail.com> wrote:
> hi!
> I wonder if there is any way to convert a flat file into a oracle
table
> without the need to create the table first. i meant an automathical
way of
> calling a text file(flat file) and create a table with it .
> Can i do this with unix also"? how?
> thank you, kevin
>
> --
> Posted via CNET Help.com
> http://www.help.com/
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Oct 06 2000 - 16:51:58 CDT