Copying sequence IDS from one db to another.

Help,

We have an application which uses Sequences. Now, is there a way of copying current (or nextvals) into an new oracle database.

Example: We have setup an environment, used the application to create data (using a Sequence), this increments the sequence and writes the row.

Now if we need to copy the environment (using imp/exp), the sequences get created, but are set to there initial value.

So, how (dynamicly) can I extract ALL sequence currval from the old database and place them into the new one.

Thanks in advance for any help you can give.

s e a n

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Aug 13 1998 - 11:12:08 CDT