ORA-12004: REFRESH FAST cannot be used for materialized view
"string"."string"
Answer / guest
Cause: The materialized view log does not exist or cannot be
used. PCT refresh is also not enabled on the materialized view
Action: Use just REFRESH, which will reinstantiate the
entire table. If a materialized view log exists and the form
of the materialized view allows the use of a materialized
view log or PCT refresh is possible after a given set of
changes, REFRESH FAST will be available starting the next
time the materialized view is refreshed.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 2 No |
ORA-02084: database name is missing a component
ORA-24755: OCI_TRANS_NOMIGRATE, OCI_TRANS_JOIN options are not supported
ORA-31602: parameter string value "string" in function string inconsistent with string
AMD-00112: PROCEDURE string, invalid mode
ORA-23395: object "string"."string" of type "string" does not exist or is invalid
ORA-02451: duplicate HASHKEYS specification
QSM-01584: equivalence, string, has anchor, string, not found in query
TNS-00269: OFF
ORA-02803: Retrieval of current time failed
ORA-13863: Statistics aggregation for service(module/action) string is not enabled
PCC-00014: Undeclared SQL Identifier "string" at line number in file string
PCC-00015: Unrecognized Host Language syntax ignored at line number in file string