Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Sequence question

665615Oct 27 2008 — edited Oct 28 2008
I am merging one database to another so that both are exact. I have 2 sequences in my script file. What is the best way to examine the sequences so that the max values do not conflict with the primary keys of the tables they are associated with.

I am not sure how to find out what tables exactly they are associated with so this is becoming a little more difficult to overcome. Is there a query I can run to find out this information?

Edited by: missnlink on Oct 27, 2008 2:49 PM
This post has been answered by Walter Fernández on Oct 27 2008
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 25 2008
Added on Oct 27 2008
16 comments
441 views