Gotchas while migrating from DB2 to Oracle.

Folks,

  I had posted article about changing isolation level in Oracle. That thread   was pretty lively. It seems Oracle will not block readers, and that   difference (from DB2) has significant impact on our application.   

  For people who has used DB2 and Oracle can you please tell me other   differences you have found so that I can be prepared, or point me to a   document/web page.

  We are porting our application from DB2 UDB (7.2) to Oracle 9i (9.2.0.4.0).

  Thanks.

-- 
Hemant Shah                           /"\  ASCII ribbon campaign
E-mail: NoJunkMailshah_at_xnet.com       \ /  --------------------- 
                                       X     against HTML mail
TO REPLY, REMOVE NoJunkMail           / \      and postings      
FROM MY E-MAIL ADDRESS.           
-----------------[DO NOT SEND UNSOLICITED BULK E-MAIL]------------------
I haven't lost my mind,                Above opinions are mine only.
it's backed up on tape somewhere.      Others can have their own.