TT-03160
REFRESH not allowed on invalid materialized view view_name
Cause
When a materialized view is invalid, the table cannot be refreshed and the owner of the view does not have SELECT privileges on every detail table referenced by that view.
Action
To fix an invalid materialized view, re-grant SELECT privileges on every detail table to the view owner (or grant higher-level privileges such as SELECT ANY TABLE or ADMIN). Once the privileges are granted, drop the materialized view and then re-create it.
Additional Information
TimesTen cannot execute the SQL statement.
TT-03160
REFRESH not allowed on invalid materialized view view_name
Cause
When a materialized view is invalid, the table cannot be refreshed and the owner of the view does not have SELECT privileges on every detail table referenced by that view.
Action
To fix an invalid materialized view, re-grant SELECT privileges on every detail table to the view owner (or grant higher-level privileges such as SELECT ANY TABLE or ADMIN). Once the privileges are granted, drop the materialized view and then re-create it.
Additional Information
TimesTen cannot execute the SQL statement.
TT-03160
REFRESH not allowed on invalid materialized view view_name
Cause
When a materialized view is invalid, the table cannot be refreshed and the owner of the view does not have SELECT privileges on every detail table referenced by that view.
Action
To fix an invalid materialized view, re-grant SELECT privileges on every detail table to the view owner (or grant higher-level privileges such as SELECT ANY TABLE or ADMIN). Once the privileges are granted, drop the materialized view and then re-create it.
Additional Information
TimesTen cannot execute the SQL statement.
