Oracle DB Error ORA-00914 missing ADD keyword

The following in the cause of this error:

The keyword ADD does not precede one of the following:

* The keyword log file in an ALTER DATABASE statement
* A column element or table constraint in an ALTER TABLE statement
* The keyword DATAFILE in an ALTER TABLESPACE statement


Action you can take to resolve this issue: Specify the keyword ADD in the ALTER statement.

Tags: Database, Education, Software

Related