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!

SQLDeveloper 17.3.1 64 bit Import Issue

Mohammed.Nov 19 2017 — edited Nov 21 2017

Hi,

When I tried to upload data from an excel sheet to a database table the upload faild.

The message says: Import for file xxxx cancelled.

The data was 122000 rows and 4 varchar2 columns.

Import success only for small number of lines.

when I tried another tool, the upload success without any issue.

I use windows 10.

PC RAM : 8 GB.

The sqldeveloper java version is the default that comes with it.

AddVMOption  -Xms1024M

AddVMOption  -Xmx2048M

So, please what to do to upload large files?

This post has been answered by Gary Graham-Oracle on Nov 21 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 19 2017
Added on Nov 19 2017
5 comments
372 views