Oracle error "ORA-00942: table or view does not exist" either means that the table/view does not exist OR that the Oracle account a.k.a. userid, used to connect does not have privileges in such table/view.
Be sure the Oracle account has privileges on the target table/view. Be sure you reference the table/view prefixing it with the schema name, just in case.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.