Return
-
Title
Creating a table using 'Load columns from file' option results in error "ORA-00902: Invalid Datat -
Description
Trying to create a table based on the headers on an Excel file using 'Load columns from file' option. I have selected option to change spaces to underscore but still getting error "ORA-00902: Invalid Datatype"
-
Cause
Column name contains a dash '-'
-
Resolution
If '-' is required in the column name then surround the column name with double quotes.
e.g.
"test - column"
Otherwise remove the dash from the name.