Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to find staging tables

621506Mar 5 2008 — edited Mar 6 2008
Hi,

I have a able in source schema, dann made a mapping in the staging area (staging schema), make a staging table from source table, dann going to core dwh to deploy the table and mapping which i made. I can valide and generate the mapping and staging table. But if i try to deploy the mapping i will get the message, that the table doese not exits, even the building was ok.
Looking into he three schemas, will not able to find the stging table. It is true when the object is not in staging schema, i will get the error.
My question ist:
How i cn find the stging table???

Here i a part of package:

CURSOR "XX_STAGE_c$1" IS
SELECT
"XX_STAGE"."aa" "bb",
"XX_STAGE"."cc" "dd"
FROM
"AA_ST"."xx_STAGE" "xx_STAGE";

Here is the eroor message:

Row-# = 11 Column-# = 3 Error text = PL/SQL: SQL Statement ignored
Row-# = 17 Column-# = 14 Error text = PL/SQL: ORA-00942: Table or view does not exists

Thanks in advance
Mandi
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 3 2008
Added on Mar 5 2008
2 comments
1,435 views