ORA-00999
Tried to create a view for later use, but it failed with ORA-00999.
Begin with Digit
SQL> create view 123 as select * from employees where salary >= 10000;
create view 123 as select * from employees where salary >= 10000
*
ERROR at line 1:
ORA-00999: invalid view name
Reserved Word
SQL> create view audit as select * from employees where salary >= 10000;
create view audit as select * from employees where salary >= 10000
*
ERROR at line 1:
ORA-00999: invalid view name
ORA-00999 means that the identifier you chose cannot be used for the view name, which is invalid and unqualified for an object name in Oracle database.
Which means, don't use any reserved words, don't use names begin with a digit either.
Solution
To have a qualified object name, you need to conform to the Oracle Database Object Names and Qualifiers.
SQL> create view happy_employees as select * from employees where salary >= 10000;
View created.
If you really want to name an object by a keyword or beginning with a digit, you should use double quotations to enclose its name. To better understanding how to properly use a quoted identifier (exact form), we have some examples for you.
For more error patterns about invalid identifier, you may refer to the post: How to Resolve ORA-00903: invalid table name.