Re: Sequence value after data refresh

"sankarKK" <xtapas_at_gmail.com> wrote in message news:8e06e45b-8099-4ad3-89cf-7a376ddf646e_at_f31g2000pri.googlegroups.com...
> 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
> tcy

How did you copy the 200 records from the proddb to the testdb? After the schema refresh?

Matthias Received on Thu Mar 31 2011 - 16:41:44 CDT