Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Re[2]: Oracle vs Mysql

Re: Re[2]: Oracle vs Mysql

From: Mladen Gogala <>
Date: Mon, 19 Jan 2004 23:04:26 -0800
Message-ID: <>

On 2004.01.19 23:39, Jonathan Gennick wrote:

> I used to use a SQL Module compiler. Not with Oracle though.
> It's rare for me to run into someone else who likes that
> approach. Actually, it's rare for me to encounter someone
> who's even heard of it...

Jonathan, I've been around for a long time. I've seen things like DataLens for Lotus123, SQL*Calc, Easy*SQL, then there was an Oracle version of then popular DB2 tool, which looked like an IBM 3874 terminal on top of VT320, SQL*Graph does deserve a honorable mention, then there was PRO*Pascal, and a myriad of other exotic stuff that I cannot remember now. I was laughing when I saw "UNDO TABLESPACES" in 9i. What exactly is a difference between a specialized undo tablespace and a file that was just laying around and couldn't be touched and was named "Before Image file" or "BI file". Logical names (another concept that many youngsters are probably unfamiliar with) were usually VAX$BI or ORACLE$BI. Unfortunately, discussions like that are not part of OCP curriculum. The file is not really part of the database, you can't create any objects in it, it manages itself and it stores the old values of oracle blocks, in case rollback is needed. I could be talking about "BI" file or "UNDO TABLESPACE", there is no difference whatsoever.

Mladen Gogala
Oracle DBA
Please see the official ORACLE-L FAQ:
Author: Mladen Gogala

Fat City Network Services    -- 858-538-5051
San Diego, California        -- Mailing list and web hosting services
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 Tue Jan 20 2004 - 01:04:26 CST

Original text of this message