ORA-00999: invalid view name

ORA-00999: invalid view name

Oracle SQL Error: ORA-00999: invalid view name

Cause:

In a CREATE VIEW statement, the view name was missing or invalid.

Solution:

Enter a valid view name following CREATE VIEW.

Example:

CREATE VIEW AS SELECT * FROM BOOKS;

Output:

SQL Error: ORA-00999: invalid view name

Correct

CREATE VIEW BOOKS_VIEW AS SELECT * FROM BOOKS;

Output:

view BOOKS_VIEW created.