79794932

Date: 2025-10-20 13:16:53
Score: 2
Natty:
Report link

The commit statement does not change the result. You will still get an error ("ORA-00942 table or view does not exist").

I suspect you ran the script with the commit when the view was known in the database. If the view exists the script will succeed with or without the commit.

Use @Maheswaran Ravisankar answer to solve the issue.

Reasons:
  • No code block (0.5):
  • User mentioned (1): @Maheswaran
  • Low reputation (0.5):
Posted by: Jörg Weigel