Originally posted by nabeel
Cause: More shared memory is needed than was allocated in the shared pool.

Try reducing the SORT_AREA_SIZE = 100MB SORT_AREA_RETAINED_SIZE = 50 MB and give 100MB to SHARED_POOL_SIZE and then try, hope you could come over the problem.
how can reducing the shared pool size help..i think he needs to increase it..arent you contracdicting yourself here ?

regards
Hrishy