I'm trying to sync a table on test system to one in production. In production, as bad as it may be, I believe they used the reserved word SITE as a column name.
alter table MY_TABLENAME modify ("SITE" varchar2(50), LOCATION_ID varchar2(50) ) ;
Above gives error:
ORA-00904: "SITE": invalid identifier
Same error without the quotes or with brackets.