| ORA-00942 | : |
Table or view does not exist |
| Cause | : |
Refering to table or view that does not exist or you don't have access to or belongs to another schema and you didn't reference the table/view by the schema name. |
| Action | : |
If table/view does not exist then you need to create them.
If you don't have priviledge to view that table/view then you need someone who do (the owner of the table/view) grant you the privilege.
If the table/view belong to the other schema refer them by using schemaname.[table/view name]. |
More Information |
Executing the following SQL statement to check if table/view exists:
select *
from all_objects
where object_type in ('TABLE','VIEW')
and object_name = '[table/view name]'; |
0 comments:
Post a Comment