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

Upgrade database from 9.2.0.7 to 10.2.0.2 and leaving COMPATIBLE to 9.2.0

TakhteJamshid Newbie
Currently Being Moderated
<pre>
Hi to all

I want to upgrade our database version (9.2.0.7) to 10g (10.2.0.2)
I know if I set COMPATIBLE parameter to 10.2.0.2 at first then I can't downgrade to 9.2.0.7 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 10.2.0.2
(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

</pre>

Legend

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