If you have scratched your head, given up on search results, looked at millions of un-answered threads I have one more solutions for you. The solution that worked for me.
In 11g Oracle there is a parameter called "_enable_row_shipping” which sometimes defaults to TRUE. Occasionally your table is huge and have large number of columns. While trying to perform select with parameter true, Oracle restricts and throws an error.
To resolve this issue, set the _ENABLE_ROW_SHIPPING to FALSE.
Once this statement is executed successfully, restart your webapp. Sometimes you might have to restart DB server(it is unlikely).
SQL statement:
alter system set "_enable_row_shipping"=false;
Soo try it out and let me know if it worked for you guys.
What is the correct statement?
ReplyDeletealter system set "_enable_row_shipping"=false;
OR
alter session set "_enable_row_shipping"=false;
Either one works.
ReplyDeleteSome system accepts only first one and some accepts both.
alter system would change it for the entire DB, alter session would change it only for your current connection/session.
ReplyDelete