Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
5 replies
Subscribers
7 subscribers
Views
2472 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
Hello, Normally, we create databases from CDTs and Datastores, and using au
Adel Ammari
over 9 years ago
Hello,
Normally, we create databases from CDTs and Datastores, and using auto generation for primary keys.
After using whichever application we develop which saves on that table, the primary key count reaches a certain number per say 20. At some point, we would like to drop all data and start clean, resetting the primary key counter back to 1.
To overcome this, we tried dropping and recreating the sequences, which seems to work well, but not for long, after resetting the counter 1, and using the system for a couple of days, we find a sudden jump, causing a non consistent primary key counter. e.g.1.2.3.4 then 21 instead of 5.
Please advise what else needs to be done to fully reset the counter to 1 causing a clean consistent primary key count 1.2.3.4.5...etc.
OriginalPostID-150883
OriginalPostID-150883
Discussion posts and replies are publicly visible
Parents
0
narasimhaadityac
A Score Level 2
over 9 years ago
Hi Adela,
While creating a sequence we have an option to specify the Cache value.please find below if cache option is specified.
The downside of creating a sequence with a cache is that if a system failure occurs, all cached sequence values that have not be used, will be "lost". This results in a "gap" in the assigned sequence values. When the system comes back up, Oracle will cache new numbers from where it left off in the sequence, ignoring the so called "lost" sequence values.
Please refer for more info -
www.techonthenet.com/.../sequences.php
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
narasimhaadityac
A Score Level 2
over 9 years ago
Hi Adela,
While creating a sequence we have an option to specify the Cache value.please find below if cache option is specified.
The downside of creating a sequence with a cache is that if a system failure occurs, all cached sequence values that have not be used, will be "lost". This results in a "gap" in the assigned sequence values. When the system comes back up, Oracle will cache new numbers from where it left off in the sequence, ignoring the so called "lost" sequence values.
Please refer for more info -
www.techonthenet.com/.../sequences.php
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data