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"
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center