Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Startup Trigger Can't Do DDL ...
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