Shared Table Definitions?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
"Table or view not found" is nothing at all to do with the table definitions. It is about incorrectly qualified table/view names, possibly caused by the table or view not being in the connecting user's default schema.
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.
Thanks for clarifying that this is unrelated to table definitions.
I'm still confused as to what is going on. The two tables are in the same schema that as the other tables used in this job. Again, I can see these tables and their data in the correct schema in SQL developer, I can even load the columns from this table, but the data isn't found.
Could it be permissions or grants on these specific tables preventing our production project from viewing the data? How can I correct that?
I'm still confused as to what is going on. The two tables are in the same schema that as the other tables used in this job. Again, I can see these tables and their data in the correct schema in SQL developer, I can even load the columns from this table, but the data isn't found.
Could it be permissions or grants on these specific tables preventing our production project from viewing the data? How can I correct that?
Last edited by iq_etl on Mon Feb 17, 2014 8:45 am, edited 1 time in total.