Database Administration (MOSC)

MOSC Banner

Sequence value after data refresh.

edited Apr 1, 2011 7:40AM in Database Administration (MOSC) 5 commentsAnswered
hi ,
after refreshing testdb from proddb  I'm having an issue 

We have 100 records in a table in testdb. Sequence=100. 200 records have been copied over from proddb. Sequence is still 100. When we try to insert next record, trigger tries to insert value 101 for the sequence, and it causes error (value not unique). So, value of sequence has be be taken from the db where we get data. I'am confused that user has been dropped with cascade, so all objects have been dropped in testdb, imported newly from proddb, how sequence value is showing old nextval.
thanks 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center