2 Replies Latest reply on Feb 2, 2016 4:24 PM by 3168474

    SQL Developer import error - text file

    3168474

      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