Tuesday, February 04, 2014

ORA-02210

I discovered a new error today while working on an Oracle 11 database. If you try to use alter table without any options, you get an ORA-02210. If you add a valid option, the error does not appear.

SQL> alter table srce.go_tpr_nhh_ppc
  2  /
alter table srce.go_tpr_nhh_ppc
                              *
ERROR at line 1:
ORA-02210: no options specified for ALTER TABLE
 
SQL> alter table srce.go_tpr_nhh_ppc enable all triggers
  2  /
 
Table altered.
 
SQL>

No comments: