Lynn Pettis (9/4/2010)
We are using 8g and 10g.
I assume you meant 8i. Oracle v8 is actually two very different animals - what we call 8 - a transitional version getting away from Oracle 7 basic concepts, then 8.1.7 which is the foundation of 9i.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.