Re: File full error in simple select statement
Posted by: Derek McKinnon
Date: April 20, 2021 06:24PM

Hi. Thanks for your reply.

No, I did not know about that setting. Reading the online help does indicate it should be the problem.

However now I can't change the value.

This is on my own laptop, logged in as root, so I checked and I do have super user privileges.

However

SHOW VARIABLES WHERE Variable_name = "max_heap_table_size";
SET PERSIST max_heap_table_size = 1000000000;
SHOW VARIABLES WHERE Variable_name = "max_heap_table_size";

Returns the same value for max_heap_table_size both before and after. I have also tried using the @@ syntax.

Any ideas?
Thanks
Derek

Options: ReplyQuote


Subject
Written By
Posted
Re: File full error in simple select statement
April 20, 2021 06:24PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.