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: Holger Baer <holger.baer_at_science-computing.de>
Date: Fri, 30 Apr 2004 10:54:33 +0200
Message-ID: <c6t489$j3h$1@news.BelWue.DE>


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 Received on Fri Apr 30 2004 - 03:54:33 CDT

Original text of this message

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