Has any one cam accross this issue ?
we have informatica job which runs every day trying to update a feild in the view.
but once in a while the session fails with error with "tablename" is not a table and from the query text i see it trying to alter a table.
And from the informatica log at the same timestamp error shows as table doesnt exist.
Databse version :14.0