I faced above error in SQL developer while I am uploading a large .xlsx file.
Cause: because of less memory it couldn't able to open. I just explicitly assigned more memory to sqldeveloper around 5000MB with following parameter.
Solution :
I just added following parameter in sqldeveloper.conf file and it start working fine .
AddVMOption -Xmx5000M
sqldeveloper.conf file location-
C:\Users\username\Downloads\sqldeveloper-18.3.0.277\sqldeveloper\sqldeveloper\bin\sqldeveloper.conf
Solution # 2 - you can convert .xlsx to .csv file using save as option. then try because csv file required less memory than .xlsx file.
Cause: because of less memory it couldn't able to open. I just explicitly assigned more memory to sqldeveloper around 5000MB with following parameter.
Solution :
I just added following parameter in sqldeveloper.conf file and it start working fine .
AddVMOption -Xmx5000M
sqldeveloper.conf file location-
C:\Users\username\Downloads\sqldeveloper-18.3.0.277\sqldeveloper\sqldeveloper\bin\sqldeveloper.conf
Solution # 2 - you can convert .xlsx to .csv file using save as option. then try because csv file required less memory than .xlsx file.
