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.

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.

Ok gracias, de todas formas, despues de muchos errores he optado por volver a instalar la versión 10.2.

Victor.