Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: db engines VS flat files

Re: db engines VS flat files

From: Greg Moore <>
Date: Sun, 09 Sep 2001 16:08:54 -0700
Message-ID: <>

> perl for handling large amounts of data (sets of flats files

People tend to push the kind of technology they are familiar with.

I've seen SQL scripts that spooled out some data to a flat file, which was then processed by a series of UNIX shell scripts. By making a simple change to the SQL and adding a two SQL*Plus SET commands, I was able to produce the flat file in exactly the form desired, eliminating the need for a half dozen UNIX fairly complex shell scripts, awk, etc.

I have no idea whether flat files and Perl, or Oracle, would be best for your system. But if the people proposing the flat file approach are all expert Perl coders who have very little experience with Oracle, their recommendations are suspect. They may just be proposing that solution because it's what they know best. They may be completely unaware of dozens or even hundreds of advantages you would miss if you don't use a relational database. It might be wise to bring in a top notch Oracle architect for a couple of weeks for a second opinion before making a decision to go back to the Stone Age and store huge amounts of data in flat files.

Please see the official ORACLE-L FAQ:
Author: Greg Moore

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Sun Sep 09 2001 - 18:08:54 CDT

Original text of this message