Need some help here regarding about the error below:-
ora_F_01: GenericQuery:esqlErrorHandler
Prepare failed for:
query is: select * from ETL_USER.F_01
sqlcode is: -942
esql complaint: ORA-00942: table or view does not exist
ora_F_01: GenericQuery::getSchema - could not prepare query 'select * from ETL_USER.F_01'.
Now, the problem is the F_01 table owner is PCAMI and somehow when I use another user (ETL_USER) to access the tables who has been granted the rights to select from the table and also a public synonym is created for the F_01 table, DataStage automatically appends an ETL_USER.F_01 at the statement. Can someone tell me how do I remove that? Any solution to this?
Using different Oracle user
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 85
- Joined: Fri Jun 04, 2004 2:30 am
- Location: Melbourne, Australia
- Contact:
-
- Participant
- Posts: 50
- Joined: Wed Jul 14, 2004 7:56 am
-
- Participant
- Posts: 85
- Joined: Fri Jun 04, 2004 2:30 am
- Location: Melbourne, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I normally include the schema (owner) name as a job parameter, and inlude it explicitly in the Table Name field.
Using a job parameter makes it easy to move from development through to production where the schema name may be different.
Using a job parameter makes it easy to move from development through to production where the schema name may be different.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Re: Using different Oracle user
The Oracle user must have access to a number of system tables.krystlecsy wrote: user (ETL_USER) to access the tables who has been granted the rights to select from the table and also a public synonym is created for the F_01 table
These are all detailed in the Enterprise: Job developers guide.