If you upgraded your 10g version to 10.2.0.3 and the OS is Solaris/AIX or HP-UX, then there is an optimizer bug.

Check Metalink for AIX/HP-UX patch or Solaris work-around.