1 Reply Latest reply on May 3, 2020 10:25 PM by Karthik Raja V

    Table or View Does Not Exist During Restore Archive Database

    Charlie Ukwu New Member

      Why would a log file tell you that "Table or view does not exist" but not tell you what tables or views.  How does one track down what tables or views do not exist?  I was performing a full restore of data archive database when this happened.

        • 1. Re: Table or View Does Not Exist During Restore Archive Database
          Karthik Raja V New Member

          Hi Charlie,

           

          Thank you for writing to us.

           

          The job might have just displayed the error message in the jobstep log. But if you check the applimation log for the same job, it would have executed a query like below in order to validate if the table exists in the database or not:

           

          SELECT * FROM HIST."TESTMAINDATA" WHERE 1=2

           

          If this validation query fails, the job will fail with "ORA-00942: table or view does not exist".

           

          Please get back to us if you have any queries on the above.

           

          Regards,

          Karthik Raja V