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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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
1,963 views