On 01/20/2004 09:39:34 AM, "Goulet, Dick" wrote:
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: Mladen Gogala INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
