Bueno pues el error ORA-00942 es este segun la pagina ORACLE ...
ORA-00942: Table or view does not exist
The table you are trying to access does not exists, or you do not have privileges to access the table.
You can use following select to determine if you have access on the table:
select owner, object_name, object_type
from all_objects
where object_name='<table_name> or <view_name>'
If you do see the table/view in the previous select, you might need to add the owner in front of the table/view name.
select * from owner.object_name
If you have to add the owner in front of the name, you can consider creating a synonym.
create synonym synonym_name for owner.object_name.
From now on you can just select from the synonym name (which is usually the same name as the table/view name).
If you do not have privileges on the table or view, grant the necessary privileges as the owner of the object:
grant select on object name to privileged user
Espero te sirva de ayuda .....
Saludos
|