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
- 4641 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-23601: PROPAGATION_NAME string does not exist
ORA-24128: partition name specified for a non-partitioned object
ORA-30104: 'string' is not a legal integer for 'string'
ORA-31652: command response message was invalid type - detaching job
NZE-29180: Unsupported validation protocol
ORA-02841: Server died on start up
PCB-00223: Undeclared variable "string"
ORA-24089: AQ Agent string already exists
ORA-09884: Two Task interface: SID doens't match current PU
ORA-23473: replication RPC processing for "string"."string" is disabled
ORA-32830: result code string returned by Messaging Gateway agent
PCB-00309: The CONNECT statement is Oracle implementation dependent
Oracle Errors 
