Robin Moffatt • 7/27/2009

ORA-00922: missing or invalid option

This technical blog post addresses the specific Oracle database error ORA-00922: 'missing or invalid option'. It details a common scenario where the error occurs when using the ALTER USER command to change a password, particularly when the new password begins with a number. The article provides the problematic SQL code, the error message, and the correct solution—enclosing the password in quotes—making it a practical guide for database administrators and developers working with Oracle SQL.

0 comments

#error handling #oracle #sql