This discussion is archived
3 Replies Latest reply: Jan 22, 2013 3:11 AM by 792858 RSS

Upgrade database from to and leaving COMPATIBLE to 9.2.0

TakhteJamshid Newbie
Currently Being Moderated
Hi to all

I want to upgrade our database version ( to 10g (
I know if I set COMPATIBLE parameter to at first then I can't downgrade to if any problem occurs
I am not sure that our application can deal with 10g or not so I think it's better to leave the COMPATIBLE parameter to 9.2.0 several days for sure
and if all things go well then change COMPATIBLE to
(I need to say that I can’t test our application in a test environment )

Now do you think leaving COMPATIBLE to 9.2.0 (after upgrade) for many days can cause any problem to Database ?

Thank you



  • Correct Answers - 10 points
  • Helpful Answers - 5 points