Sreejith, From dealing with upgrades since V3 there is never a case of something that worked in an earlier version that does not still work today, or at least I haven't run across one. Now how well the earlier behavior of parts of the DB work and what impact that may have on your application is another matter all together. I remember that back in Oracle 8.1.6 they changed the behavior of the group by clause. In previous versions it would return the list in ordered fashion as if you had added an order by clause. But all of a sudden that changed so that group by returned the list in random fashion based on which row came out of the db first, sorta as if you had done an order by rowid clause. That caused more trouble than I care to remember as many applications had been dependant of the earlier behavior. And believe me that can be a real bear to find. Dick Goulet Senior Oracle DBA/NA Team Lead PAREXEL International ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Sreejith S Nair Sent: Tuesday, June 22, 2010 6:04 AM To: oracle-l@xxxxxxxxxxxxx Subject: Things which are removed in Oracle 11G from 10G Hi, Is there any way to check which all things available in Oracle 10G , are not available in 11G. I am just trying to gather if there is anything our application was using while it was running in 10G and in any case, it is not available in 11G. I hope everything must be forward compatible. I am sure there will be only new additions.just to confirm... please help if there is any way to check this. Many Thanks, Sreejith Nair DISCLAIMER: "The information in this e-mail and any attachment is intended only for the person to whom it is addressed and may contain confidential and/or privileged material. If you have received this e-mail in error, kindly contact the sender and destroy all copies of the original communication. IBS makes no warranty, express or implied, nor guarantees the accuracy, adequacy or completeness of the information contained in this email or any attachment and is not liable for any errors, defects, omissions, viruses or for resultant loss or damage, if any, direct or indirect."