Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-12047: PCT FAST REFRESH cannot be used for materialized
view "string"."string"
- 1 Answers
- 4701 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: PCT refresh is either not enabled on this
materialized view or not possible after set of the base
table changes since last refresh.
Action: Use just REFRESH FORCE, which will reinstantiate the
entire table and try to pick the best refresh method on the
materialized view Do explain_mview to look at the cause why
PCT refresh is not possible on this materialized view
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-09838: removeCallback: failure removing the callback port.
NNL-00578: dump_ldap: dump addresses in the domain or region to LDAP
EXP-00090: cannot pin type "string"."string"
ORA-28656: incomplete attribute specification
DRG-11127: inconsistent index policy with trained rule
ORA-32775: cannot change size attributes of read only tablespace string
DRG-12502: cannot modify stoplists owned by other users
RMAN-08545: flashback command failed: See trace file for details
ORA-39095: Dump file space has been exhausted: Unable to allocate string bytes
ORA-02222: invalid PCTINCREASE storage option value
PLS-00358: column 'string' exists in more than one table; use qualifier
ORA-02396: exceeded maximum idle time, please connect again
Oracle Errors 
