This content has been marked as final. Show 5 replies
are your grants in the database set up correctly?
Source datasource xxx/yyy and target data source aaa/bbb.
In deployement path i am getting error like ORA-00942: table or view does not exist.
How to give privellage to target schema?
source and taget have different data base.
Help me regarding this.
Create a dynamic sql script that grants to all tables in source to target..1 person found this helpful
grant select on ||table_name|| to target_schema.
Hi,1 person found this helpful
don't know if your problem is solved.
But if not, if you want to use a table from a different database you have to create a new module (e.g. MOD_1) which is pointing to the database and the schema, for e.g Source datasource xxx/yyy .
OWB creates a location with the needed informations. You should find them under Locations Navigator --> Locations --> Databases --> Oracle
Import your table you want to use in a mapping in this module (via design center).
Now you can create a mapping in your Module (e.g. MOD_2) which is pointing to target data source aaa/bbb.
Here you can drag and drop the table to the mapping designer.
When you deploy the Mapping owb will create a dblink. This dblink can be found under the location which belongs to MOD_2 (DB Connectors).
Hope this helps.
I missed to set data location for the source schema. I found this from mapping scripts.
Edit our source module and check metadata location and data locations.
Move ur source location from Available locations to selected locations.