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-39081: failed to unsubscribe agent string from queue "string"
IMG-00911: free basic data structure failed
ORA-27064: cannot perform async I/O to file
ORA-24777: use of non-migratable database link not allowed
DRG-11506: record ignored on line string because of error(s)
SQL-02149: ANSI Dynamic insufficient item descriptor areas
ORA-00823: Specified value of sga_target greater than sga_max_size
RMAN-06057: a standby controlfile cannot be included along with a current controlfile
ORA-12078: fast refresh of refresh group ID string failed
ORA-12068: updatable mview log for mview "string"."string" does not exist
ORA-02363: error reading from file: string
ORA-19646: cannot change size of datafile string from string to string