adjusting sequences

take a look at this script: http://www.oramag.com/code/cod06247.html

--
Joseph S. Testa, Oracle Database Administrator, mailto:jtesta_at_scioto.net

Are you looking for Oracle DBA in Central Ohio, but only want one for
some part-time work? try http://web.scioto.net/jtesta
That is also the place to find the FREE, "how do I build a second,
third, etc, instance, without using oracle's installer, database
scripts.
ICQ UIN: 2814105(Joe-N8XCT, Home) UIN: 2832230(&oracle, work).