http://cashmanagementcm.blogspot.com/2017/01/transfer-number-skips-in-bank-account.html
a.
alter Sequence CE.CE_PAYMENT_TRANSACTIONS_S NOCACHE;
b.
select min_value, max_value,increment_by, cache_size, last_number from all_sequences where
sequence_name like 'CE_PAYMENT_TRANSACTIONS_S%';
It should return one row with value: cache_size as 0
No comments:
Post a Comment