java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

You saw this error when you execute a query.

java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)

        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)

        at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1017)

        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655)

To fix it, login to the database to verify if the table or view exists.

If the table or view does not exist, create the table or view.

If the table or view is there, check to see if the table or view belongs to the correct schema using the SQL below.

      select owner, table_name from all_tables where table_name='<table name>';

If the owner of the table is other than what you have expected, create the table with the correct schema. Usually, the owner is also the schema name.

    create table <correct schema>.<table name> as select * from <unexpected schema>.<table name>; 

-----------------------------------------------------------------------------------------------------------------

Watch the blessing and loving online channel: SupremeMasterTV live

If you have ever asked yourself these questions, this is the book for you. What is the meaning of life? Why do people suffer? What is in control of my life? Why is life the way it is? How can I stop suffering and be happy? How can I have a successful life? How can I have a life I like to have? How can I be the person I like to be? How can I be wiser and smarter? How can I have good and harmonious relations with others? Why do people meditate to achieve enlightenment? What is the true meaning of spiritual practice? Why all beings are one? Read the book for free here.