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.
> I wonder if there is any way to convert a flat file into a oracle
> without the need to create the table first. i meant an automathical
> 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
Sent via Deja.com http://www.deja.com/
Before you buy.