ORA-00904: : invalid identifier when alter add column

[fiksani]

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
build 142

I have some issues:

1. Cannot delete column
   

2. Cannot alter column, invalid identified (not need 'column')
   

[huyphams]

Thanks, let me check it.

[huyphams]

There are two ways to drop a column, should I use physical delete column? @fiksani
https://oracle-base.com/articles/8i/dropping-columns

[fiksani]

Yes, you can use physical delete column.

[josephcantrell14]

Altering OracleDB table columns through the GUI and through SQL Queries is broken. The invalid identifier error still persists. The only solution with TablePlus is to delete the table and recreate it.