1 Reply Latest reply on Aug 30, 2019 9:52 PM by thatJeffSmith-Oracle

    SQLDeveloper Import Wizard nullable field issues

    user10494433

      I'm having an issue with the Import Wizard and loading a CSV file into a table.

      i created the table where all the fields are NULLABLE = YES.

       

      i matched up the fields to the data columns but there are 4 columns (1 numeric and 3 date type) that are throwing errors and failing inserts because they contain null values and i get the error "Data is not compatible with column definition or is not available for a not nullable column". 

      except every single field in the table is NULLABLE = YES. 

       

      why does the import wizard ignore the NULLABLE value. 

      in step 4 of 5 in the Data IMport Wizard, i even see the the Nullable? checkbox is checked, but gray.

       

      What's going on?????