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!

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
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 1 2016
Added on Feb 2 2016
2 comments
12,019 views