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.