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
- 4624 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-16736: unable to find the destination entry of standby "string" in V$ARCHIVE_DEST
PCC-00143: Runtime context variable not of correct type
ORA-19700: device type exceeds maximum length of string
ORA-36997: (XSRELGID14) For variable or relation grouping ids, a level relation is needed when a level order valueset is specified.
ORA-01905: STORAGE keyword expected
ORA-24814: operation not allowed for temporary LOBs
ORA-16776: Health check of the log transport service failed.
ORA-12989: invalid value for checkpoint interval
ORA-16151: Managed Standby Recovery not available
ORA-15048: ASM internal files cannot be deleted
ORA-10614: Operation not allowed on this segment
ORA-01350: must specify a tablespace name
Oracle Errors 
