Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-12034: materialized view log on "string"."string"
younger than last refresh
- 2 Answers
- 8427 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
Cause: The materialized view log was younger than the last
refresh.
Action: A complete refresh is required before the next fast
refresh.
Please add more information about this Error
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / giriraj
First use this statement :
==============================
execute dbms_snapshot.refresh
('SCHEMA_NAME.TABLE_NAME', 'C');
Then
execute dbms_snapshot.refresh
('SCHEMA_NAME.TABLE_NAME', 'F');
| Is This Answer Correct ? | 1 Yes | 0 No |
NNO-00305: trace level changed from number to number
TNS-12504: TNS:listener was not given the SID in CONNECT_DATA
RMAN-07507: cataloging files...
QSM-01025: materialized view, string, not found
ORA-16177: media recovery is not required
DRG-50607: failed to obtain column info for cid string
ORA-02366: The following index(es) on table string were processed:
ORA-23477: unable to alter propagation mode for object group "string"."string"
RMAN-06005: connected to target database: string (DBID=string)
QSM-02149: ON COMMIT with this MV requires 9.0 compatibility or higher
ORA-01114: IO error writing block to file string (block # string)
PLS-00103: %s
Oracle Errors 
