RE: Re[2]: Oracle vs Mysql

Careful Mladen, your revealing your age!! Bet you remember RPT & RPF as well!!

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-----Original Message-----
Sent: Tuesday, January 20, 2004 2:04 AM
To: Multiple recipients of list ORACLE-L

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: http://www.orafaq.net
-- 
Author: Mladen Gogala
  INET: mgogala_at_adelphia.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Goulet, Dick
  INET: DGoulet_at_vicr.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (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).