Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

COMPATIBLE Parameter and Features

538022Nov 26 2007 — edited Nov 27 2007
Hello guys,
maybe you can help me ... we've got some Oracle 9.2.0.7 databases and want to upgrade them to 10.2.0.3.

In every documentation we can found the following for the compatibility in case of a downgrade:

http://download.oracle.com/docs/cd/B19306_01/server.102/b14238/compat.htm#sthref245
-> It controls the behavior of your database. For example, if you run a release 10.2 database with the COMPATIBLE initialization parameter set to 9.2.0, then the release 10.2 database generates release 9.2 compatible database structures on disk. Therefore, the COMPATIBLE initialization parameter enables or disables the use of features. If you try to use any new features that make the database incompatible with the COMPATIBLE initialization parameter, then an error is displayed. However, any new features that do not make incompatible changes on disk are enabled.

Or the parameter itself:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/initparams028.htm#sthref131
->This parameter specifies the release with which Oracle must maintain compatibility. It allows you to take advantage of the maintenance improvements of a new release immediately in your production systems without testing the new functionality in your environment. Some features of the release may be restricted.

Ok but where can i find a list of the "new" features that are not supported/possible in the compatibility mode for 9.2.0.7?

You would help me very much.

Thanks and Regards
Stefan
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 25 2007
Added on Nov 26 2007
6 comments
541 views