Re: oracle warehouse builder

Did you import the table, or just create it?

If you created the table in OWB and not in the database, then you must create the table in the database and import it, or deploy the OWB table into the database.

If you log into the target the schema, can you see the table? If you log into the OWB schema, can you see the table? You must be able to see it in both places. If you can see it in the target schema, follow the directions above. If you can see it in the target schema and not in the OWB schema, make sure there is a database link in OWB --> target (also synonyms are good).

Always deploy the mapping into the target schema.

"Chandra shekar" <shekar_at_cmcltd.com> wrote in message news:a30bf6aa.0305080504.44de4598_at_posting.google.com...
> In oracle ware house builder tool i want to create a mapping in
> between two users.
>
> in that first i create a module with data source having the the dblink
> to source. and i imported the tables from it.
>
> next i created module for target.with data warehouse target.and
> created a table in that user.(make it created).
>
> next i selected mappings and create a new mapping and add the mapp
> tables of both source and target. and made mapping between them.
>
> and validate it and then i generated it. while generating it when i
> deploy it
> with the runtime connection .
>
> if i give the runtime connection as the source user/passwd it is
> giving error
> " databaselink failed to the target one. "
>
> if i give the runtime connection as the target user/passwd it is
> giving errors
> identifier not found...., table doesn't exit....etc " errors.
>
> i need how to solve it.if possible send me the steps to create mapping
> between two users...
>
Received on Sun May 11 2003 - 05:29:32 CEST