Getting error "ORA-00984: column not allowed here" when creating a table with the wizard.
The table has a char column with a default value.
The script generated by the Wizard is:
CREATE TABLE USER.test
(
test CHAR(1) DEFAULT N
)
LOGGING
NOCOMPRESS
NOCACHE
NOPARALLEL
NOMONITORING
and the error is
"Error at line 3
ORA-00984: column not allowed here"
The default value is not enclosed between ''
Please enclose the default value between ''
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center