Quote Originally Posted by lencuff
I am trying to migrate an 8i database to 9i with as little pain as possible. I have been told that if I use the 'compatible parameter' set to 8.1.2 then it will all go smoothly? Where do I put this parameter and is this correct info?
You would put it in you init file. But then you would not have 9i optimizer features. If you have been using rollback segments with set transaction statements to get the big rollback, then going to automatic undo will require pulling the set transaction statements from your code. If you don't then using the compatability flag might not do anything for you. But once you test your upgrade in dev you will know the answer.