Re: problem in creating a new sequence(oracle 8i web db)
From: srivenu <srivenu_at_hotmail.com>
Date: 5 Mar 2002 21:56:19 -0800
Message-ID: <1a68177.0203052156.9eb9479_at_posting.google.com>
Date: 5 Mar 2002 21:56:19 -0800
Message-ID: <1a68177.0203052156.9eb9479_at_posting.google.com>
You may loose sequence values even without shutting down the database
if the Sequence Cached are flushed from the Shared Pool.
Example: Try select the next value of a sequence before and after
giving the following statement.
ALTER SYSTEM FLUSH SHARED_POOL
Received on Wed Mar 06 2002 - 06:56:19 CET