Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> PLSQL loop?
Hi!
You could make a little PLSQL with a loop that picks sequence_n.NEXTVAL until some reasonalble condition is reached. If the exact value of the sequences are of interest (I hope not) creating a script based on data dictionary/current values in the old database may be possible. Sadly not quite a "newbie task", but I haven't time to write one right now :-( If questionee post a request for it, I can give it a try tomorrow.
Frank, Received on Wed May 09 2001 - 17:03:46 CDT
![]() |
![]() |