ANNOUNCEMENT: community.oracle.com is currently Read only due to planned upgrade until 28-Sep-2020 9:30 AM Pacific Time. Any changes made during Read only mode will be lost and will need to be re-entered when the application is back read/write.
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.