Knowledge Base : DBA USERS.AUTHENTICATION TYPE is missing

“I am getting: ORA-00904: “DBA_USERS”.”AUTHENTICATION_TYPE”: invalid identifier on some systems”.

AUTHENTICATION_TYPE was introduced in data dictionary column DBA_USERS in 11.1.

See also Oracle Documentation.