Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Startup Trigger Can't Do DDL ...

Re: Startup Trigger Can't Do DDL ...

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Fri, 30 Apr 2004 19:40:49 +1000
Message-ID: <40921f1a$0$20085$afc38c87@news.optusnet.com.au>


Holger Baer wrote:

> Howard J. Rogers wrote:
>

>>
>> And never mind the loss of numbers when an instance crashes: what 
>> about the loss of numbers that will happen when somebody rolls back 
>> their transaction (or suffers a blue screen of death in 
>> mid-transaction and has PMON roll it back for them)? Or when the 
>> junior DBA wanting to know what the last sequence number issued was 
>> happens to select from currval?
>>

>
> Just curious (or lazy if you wan't, because I didn't dig into the
> documentation just now): What do you think that happens?
> Selecting from currval returns the last retrieved number for the *CURRENT*
> session - if it had never been retreived you get an
>
> select sequencename.currval from dual;
>
> ORA-08002: sequence <sequencename> is not yet defined in this session
>
>
> This is what a quick test on 10g confirmed.
>
> Regards,
>
> Holger

It's true for 9i, too. Dunno, really.

Regards
HJR Received on Fri Apr 30 2004 - 04:40:49 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US