Friday, 20 January 2017

Transfer Number Skips in Bank Account Transfers

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