ORA-00942: table or view doesn't exists
2 participantes
Página 1 de 1.
ORA-00942: table or view doesn't exists
Hi all,
I have installed OWB 11g in WXP. Then I execute the repository assistant in order to create the repository. Then I get the following error:
ORA-00942: table or view doesn't exists
I specify the owner user and the user for Designer. I also include the DWH's user where I have all the target tables.
The error occurs when the assistant try to execute the package: WB_WORKSPACE_MANAGEMENT:
runSqlScript() ======= Invalid SQL: call owbsys.wb_workspace_management.create_workspace('OWB11', 'OWB_PRO')
java.sql.SQLException: ORA-00942: table or view does not exist
I also have compiled this package and the result was successful.
Did someone face the same problem?
Thanks in advance,
Victor.
I have installed OWB 11g in WXP. Then I execute the repository assistant in order to create the repository. Then I get the following error:
ORA-00942: table or view doesn't exists
I specify the owner user and the user for Designer. I also include the DWH's user where I have all the target tables.
The error occurs when the assistant try to execute the package: WB_WORKSPACE_MANAGEMENT:
runSqlScript() ======= Invalid SQL: call owbsys.wb_workspace_management.create_workspace('OWB11', 'OWB_PRO')
java.sql.SQLException: ORA-00942: table or view does not exist
I also have compiled this package and the result was successful.
Did someone face the same problem?
Thanks in advance,
Victor.
vcp- Cantidad de envíos : 10
Localización : Tarragona (Spain)
Fecha de inscripción : 10/09/2009
Re: ORA-00942: table or view doesn't exists
Este error está reportado en Metalink con el número de nota 557067.1. En teoría hay que hacer una limpieza del usuario OWBSYS, propietario del espacio de trabajo (nuevo concepto de OWB 11g) y volver a lanzar el asistente de repositorio.
Begoña.
Begoña.
Re: ORA-00942: table or view doesn't exists
Ok gracias, de todas formas, despues de muchos errores he optado por volver a instalar la versión 10.2.
Victor.
Victor.
vcp- Cantidad de envíos : 10
Localización : Tarragona (Spain)
Fecha de inscripción : 10/09/2009
Página 1 de 1.
Permisos de este foro:
No puedes responder a temas en este foro.