|
#1
|
|||
|
|||
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 |
Herramientas | Buscar en Tema |
Desplegado | |
|
|