Re: Rollback Segments

Bambi,

HLI and OCI - that reminds me of another nice one from the dark ages. Some of you around here, who consider yourself "old" in terms of Oracle may remember, the oci call osql3(), which was later superceeded by oparse() (version 6/7-ish, I think). Well, the reason for the old call being called osql3() was that it was new with version 3! In version two, osql() was found, but it was limited to 6000 bytes of SQL statement text, where osql3() made it possible to go to to 64k.

Rgds, Bjørn.

On Tuesday 19 February 2002 20:18, you wrote:
> Bjorn, you old coot, you've got me beat. I do remember the UFI prompt
> though... User Friendly Interface... and the "real geeks" would program
> their own SQL*Plus environment using HLI (now OCI) with the OROL option
> which would allow the rollback of a single statement rather than a whole
> transaction. Now, in my day, we had fire but we had to make our own coal
> and we kept warm on the hides of old terminals that used to roam the
> plains. What were things like in your day?
>
> Bambi.
>
>
> -----Original Message-----
> Sent: Tuesday, February 19, 2002 5:23 AM
> To: Multiple recipients of list ORACLE-L
>
> There must be somebody beside myself remembering version 3, which did not
> have read consistency - the great new feature of version 4. In 3, doing
>
> UFI> insert into emp select * from emp;
>
> would cause anything from having 28 rows in emp till having and endless
> loop
>
> in the kernel only finishing when your database file ran full...
>
> Yep - we are some old bitter men around here...
>
> /Bjørn.
>
> On Tuesday 19 February 2002 06:43, you wrote:
> > I remember the BI.ORA (Before-Image) file, IOR and ODS in Oracle 5.
> >
> > Hemant K Chitale
> > Principal DBA
> > Chartered Semiconductor Manufacturing Ltd
> >
> >
> > Rachel Carmichael <wisernet100_at_yahoo.com> 19/02/2002 06:18 AM
> > Sent by: root_at_fatcity.com
> >
> > Please respond to ORACLE-L
> >
> > To: Multiple recipients of list ORACLE-L
> > <ORACLE-L_at_fatcity.com> cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST
> > Group) Subject: RE: Rollback Segments
> >
> >
> >
> >
> >
> >
> >
> >
> > UFI no, but the rest... that's where I started in Oracle -- version 5
> >
> > --- "Conboy, Jim" <Jim.Conboy_at_trw.com> wrote:
> > > Holy cow Mladen, what a memory!
> > >
> > > Does anybody else remember (or admit to) using UFI?
> > >
> > > Jim
> > >
> > > **************************************************************
> > >
> > > ...does anybody still remember VAX/VMS, ORACLE$BI, IOR and ODT?...
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Conboy, Jim
> > > INET: Jim.Conboy_at_trw.com
> > >
> > > 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: 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).
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Yahoo! Sports - Coverage of the 2002 Olympic Games
> > http://sports.yahoo.com
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Rachel Carmichael
> > INET: wisernet100_at_yahoo.com
> >
> > 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: 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.com
-- 
Author: =?iso-8859-1?q?Bj=F8rn=20Engsig?=
  INET: bjorn_at_MiracleAS.dk

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: 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).