Skip to Main Content
  • Questions
  • Downgrade a fresh 11.2.0.4 database [not upgraded] to 11.2.0.1

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, shiva shekar.

Asked: February 26, 2017 - 4:06 pm UTC

Last updated: February 27, 2017 - 12:52 am UTC

Version: 11.2.0.4

Viewed 1000+ times

You Asked

Hi Tom,

I need to downgrade a newly installed database 11.2.0.4 to 11.2.0.1, Is it possible?, please let me know the steps involved. There is a metalink note but it is only for databases which were previously upgraded.

Thanks a lot in advance.
Shiva

and Connor said...

When you say "newly installed" do you mean there is nothing in there of yours, ie, just an empty clean database ?

If that's the case, why not just create a database using 11.2.0.1 ?

But in any event, I would suspect that your 'compatible' parameter might be at its default on 11.2.0.4 ? If so, then you can't downgrade, because the datafiles have been stamped as 11.2.0.4.

If compatible is 11.2.0.1, then you could run the downgrade scripts as per the upgrade guide.

If you just want the optimizer to work as if it was in 11.2.0.1, I'd just set optimizer_features_enabled appropriately and leave it at 11.2.0.4

Hope this helps.

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

A reader, February 27, 2017 - 8:36 pm UTC

I was curious if there is any method to do it.

Thanks for explaining!!

Thank you
Shiva




More to Explore

Performance

Get all the information about database performance in the Database Performance guide.