Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-32320: REFRESH FAST of "string"."string" unsupported
after container table PMOPs
- 2 Answers
- 6335 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
Cause: A Partition Maintenance Operation (PMOP) has been
performed on the materialized view, and no materialized view
supports fast refersh after container table PMOPs.
Action: Use REFRESH COMPLETE. Note: you can determine why
your materialized view does not support fast refresh after
PMOPs using the DBMS_MVIEW.EXPLAIN_MVIEW() API.
Please add more information about this Error
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / mahesh
If the Table is not a Partitioned one then also it is
throwing the same exception.
How is this possible.
| Is This Answer Correct ? | 0 Yes | 0 No |
DRG-11210: format column must be a char, varchar, or varchar2 type
ORA-36182: (XSAGGR09) Could not locate a value for variable number in measure dimension workspace object.
NCR-04021: NCRR: Pickler errors
ORA-12024: materialized view log on "string"."string" does not have primary key columns
ORA-39025: jobs of type string are not restartable
KUP-04072: error writing to file string
ORA-00827: could not shrink sga_target to specified value
ORA-13287: can't transform unknown gtype
KUP-04011: file system is full
TNS-01106: Listener using listener name string has already been started
ORA-01453: SET TRANSACTION must be first statement of transaction
ORA-01641: tablespace 'string' is not online - cannot add data file
Oracle Errors 
