Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Startup Trigger Can't Do DDL ...
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? >>
It's true for 9i, too. Dunno, really.
Regards
HJR
Received on Fri Apr 30 2004 - 04:40:49 CDT