Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm taking a class in Databases, they're using Oracle 10g in class, but I'm having some trouble installing the database here in Windows 8 (auth problems), so I thought I'd attempt 11g.

Is 11g backwards compatible?

As in, just for learning, will I be able to not use the added 11g features?

share|improve this question
up vote 6 down vote accepted

Are you really trying to use Windows 8? No version of Oracle is supported on Windows 8 yet and, if history is any guide, I wouldn't expect any of them to work without patches that aren't available yet. Is Windows 8 even in public beta yet? I'd hate to try to take a class using an early beta operating system.

Oracle 11.2 is supported on Windows 7 (which seems like a more realistic Windows version). If you have Windows 7, that's realistically the version you need to install.

What, exactly, does the class cover? If you are learning how to do data modeling and to write basic SQL and PL/SQL, you should be fine using 11g since everything will be backwards compatible. If, on the other hand, your instructor is teaching about database administration or is making heavy use of the Oracle Enterprise Manager (OEM) GUI, there are going to be a lot of visual differences that you'd have to compensate for across versions. You can almost certainly get the same information from the 11g OEM GUI, it just may be in a slightly different place.

share|improve this answer
Thanks. Windows 8 available here: Just basic SQL and PL/SQL. I will install 11g, thanks for confirming. – A T Sep 21 '11 at 3:34

You should be able to do everything you learn about 10g with 11g as well. In fact, I would recommend to go for the most current version anyway, if you have the choice.

share|improve this answer
A notable exception would be if the class created a table and did not expect Deferred Segment Creation. – Leigh Riffel Sep 20 '11 at 16:55
"The CREATE TABLE statement now supports the following segment creation clause." So I'm pretty sure that means that if I don't include it, I won't be affected by new features? – A T Sep 21 '11 at 3:31

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.