We have a view and whenever I use it, it gave me below error.
ERROR: ORA-04030: out of process memory when trying to allocate 64544 bytes (sort subheap,sort key).
select * from yu_view
where term_code >=code;
This view has so many colums and use many functions.
Please help.
Thank you.
Thank you. The view is used for many report and I cannot re-create. I cannot change the database setting either. I will write more functions and procedures instead of using this view.
Thank you for all your response.