Skip to Main Content
Forums

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.

SQL Developer import error - text file

3168474Feb 2 2016 — edited Feb 2 2016

Hello,

I'm new to SQL developer - I am getting an ambiguous error when I try to import a pipe-delimited text file into an empty Oracle table that I've created and defined specifically for this data set.

Error message: "File C:\Users\dgerace\Desktop\dona.txt cannot be opened due to the following error: null." When I click help, it says it cannot file the help topic for IMPORT_OPEN_FILE_ERROR.  It seems to be able to import an excel file without issue.

The file 'dona.txt' is a tiny sample of the original file I'm trying to import so it is an overall import text file problem.

Thank you for any help.

Donna

Comments

user8609728
Answer

Hi, I've hit the same problem, see

https://access.redhat.com/security/vulnerabilities/stackguard?sc_cid=70160000000gzltAAA&

To fix I changed the commonenv file found in middleware/bin to hash out this line

    #ulimit -S -s $EM_THREAD_STACK_SIZE

Marked as Answer by Praveen Alluri · Sep 27 2020
2 people found this helpful
Praveen Alluri

Than you very much.. This fixed my issue.

Appreciate your help on this,

Regards,

Praveen

user6707569

Ideed this is correct.

1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 1 2016
Added on Feb 2 2016
#sql-developer
2 comments
11,926 views