Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

What is the largest size file that can be imported as a table into SQL Developer?

User_PDJALJun 4 2021

When I initially tried importing a 45 MB Excel file, I got an error related to "java heap space". Then after some limited research, I closed down my SQL Developer app, added the following new line to my "sqldeveloper.conf" file in my '\sqldeveloper-20.4.1.407.0006-x64\sqldeveloper\sqldeveloper\bin' subfolder: "AddVMOption -Xmx1024M", and tried again but now I get this error:
"File C:\Users\tpidding\Desktop\EEM_Monitoring\TABLE_EXPORT_DATA.xlsx cannot be opened due to the following error: GC overhead limit exceeded."

Comments
Post Details
Added on Jun 4 2021
2 comments
2,329 views