Skip to content
Home » Oracle » How to Resolve ORA-00999: invalid view name

How to Resolve ORA-00999: invalid view name

  • Oracle

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.

Leave a Reply

Your email address will not be published. Required fields are marked *