It's all about the answers!

Ask a question

DataWarehouse issues


Mark Ireland (26115548) | asked Nov 20 '12, 6:35 a.m.
We have problems with our DW in that when we look at DW status we get that the data warehouse is not configured.
We have gone through setup and it is all clear.
The logs show the issue as :-

"java.sql.SQLException: ORA-00942: table or view does not exist"

We wondered if the following would resolve?

Backup DB's
Drop / recreate DW
Rerun setup OR repotools-<all_apps> -createWarehouse

Finally, How do we find out what table or view it is upset over?

Regards

Mark.

One answer



permanent link
Mark Ireland (26115548) | answered Nov 20 '12, 8:12 a.m.
Required a stop a start after rerunning the setup and ensuring the oracle user have correct perms.

Your answer


Register or to post your answer.