title: Porting an application from Oracle 9 to Oracle 11 - gottchas?
body: <p>We have an application (well, 3) which uses Oracle 9i, however this is being end-of-life-ed shortly, and we need to move to another platform - Oracle 11 or Postgress being the obvious ones.</p>
  
  <p>I've heard comments to the effect that porting from 9i to 11 isn't straight forward,  but no-one here can confirm one way or the other. I'm not overly concerned with "oh, the query plan engine changed", I'm more concerned with "this feature isn't there anymore".</p>
  
  <p>None of the apps are complex - it's either basic crud stuff in client-side SQL (and a big multi-table search routine, but we are going to rewrite that using Lucene anyway), or the same in PL/SQL.</p>
  
  <p>Postgress only came up as a possibly easier and cheaper target to port to, but the license cost is offset by the training cost for our DBAs.</p>
  
  <p>Any experience comments appreciated.</p>