Home » Server Options » Replication » ORA-12034 Error (Oracle Database 10g Enterprise Edition 10.2.0.4.0)
ORA-12034 Error [message #461837] Mon, 21 June 2010 14:34 Go to next message
ole2009
Messages: 12
Registered: May 2009
Junior Member
Hi,

I get ORA-12034 ERROR after I drop the master table and rebuild the master table.

Here are the steps that I did:

1 Export the master table.
2 Drop the master table.
3 Import the master table to the other table space.
4 Create the materialized view log for the master table.
5 Refresh the materialized views that based on the master table with the following command:

DBMS_MVIEW.REFRESH('my_mv', 'F');


6 Get the oracle error:
ORA-12034: materialized view log on "scott"."my_table" younger than last refresh
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2251
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2457
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2426
ORA-06512: at line 2


Questions:
1 Do I need to rebuild all the materialized views that based on the same master table?
2 Could I refresh the materialized view with a complete refresh first and then fast refresh everyday ?

DBMS_MVIEW.REFRESH('my_mv', 'C');


Thanks for your help

TC



[Updated on: Mon, 21 June 2010 14:39]

Report message to a moderator

Re: ORA-12034 Error [message #461843 is a reply to message #461837] Mon, 21 June 2010 15:12 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-12034: materialized view log on \"%s\".\"%s\" younger than last refresh
 *Cause:  The materialized view log was younger than the last refresh.
 *Action: A complete refresh is required before the next fast refresh.

Regards
Michel
Re: ORA-12034 Error [message #461847 is a reply to message #461843] Mon, 21 June 2010 16:20 Go to previous message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

>>1 Do I need to rebuild all the materialized views that based on the same master table?

No

>>2 Could I refresh the materialized view with a complete refresh first and then fast refresh everyday ?

Yes. As Michel suggest

Babu
Previous Topic: Doubt in Replicating Data from DB to another
Next Topic: Oracle GoldenGate
Goto Forum:
  


Current Time: Thu Mar 28 07:02:04 CDT 2024