If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Compatible parameter

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?

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.

I don't want to do the upgrade!! The only reason for having to do it is that we have to migrate from NT4 to W2K and we can'y lay our hands on a working CD for 8i. If I could find a download for 8i then that's the way I would go. No pain at all!! but I can't lay my hands on a copy of 8i despite searching for hours.