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
- 4643 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 |
TNS-04206: Trace Assistant Internal ERROR: Packet Type
ORA-01051: deferred rpc buffer format invalid
ORA-32021: parameter value longer than string characters
ORA-07489: scgrcl: cannot get lock status.
ORA-33092: (XSAGCOMP04) number is not the name of a MODEL in any attached analytic workspace.
ORA-29703: error occurred in global enqueue service operation
ORA-38492: invalid ALTER INDEX parameters clause "string"
ORA-19659: incremental restore would advance file string past resetlogs
ORA-00024: logins from more than one process not allowed in single-process mode
RMAN-06169: could not read file header for datafile string error reason string
ORA-19555: invalid LOG_ARCHIVE_MIN_SUCCEED_DEST parameter value
ORA-30936: Maximum number (string) of 'string' XML node elements exceeded
Oracle Errors 
