ORA-12004: REFRESH FAST cannot be used for materialized view
"string"."string"



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

Post New Answer

More Oracle Errors Interview Questions

ORA-21526: initialization failed

1 Answers  


PLS-01409: Use of 'PRIOR_' token

1 Answers  


ORA-02041: client database did not begin a transaction

1 Answers  


ORA-38774: cannot disable media recovery - flashback database is enabled

1 Answers  


PLS-00310: with %%ROWTYPE attribute, 'string' must name a table, cursor or cursor-variable

1 Answers  






ORA-22160: element at index [string] does not exist

1 Answers   ICICI,


ORA-07446: sdnfy: bad value 'string' for parameter string.

1 Answers  


ORA-22982: cannot create sub-view under this view

1 Answers  


ORA-08433: invalid picture type in convert raw to number

1 Answers  


DRG-50906: score threshold string is not an integer

1 Answers  


ORA-25408: can not safely replay call

2 Answers  


ORA-25294: Queue string has a buffer

1 Answers  


Categories