Getting generic Oracle error message 'missing right parenthesis'
This is not a &quot;more generic error&quot;, it indicates that the order of some clause in your SQL statement is incorrect, and Oracle does not find a valid clause where it expects it. You should check the manual for the correct syntax for CREATE TABLE.
There you will find in particular this description of a column definition:

column [ datatype [ COLLATE column_collation_name ] ]
  [ SORT ] [ VISIBLE | INVISIBLE ]
  [ DEFAULT [ ON NULL ] expr | identity_clause ]
  [ ENCRYPT encryption_spec ]
  [ { inline_constraint }...
  | inline_ref_constraint
  ]


that tells you that the DEFAULT clause comes before any constraints, of which NOT NULL is one.