OraFAQ Forum: Replication » ORA-12034 Error

Home » Server Options » Replication » ORA-12034 Error (Oracle Database 10g Enterprise Edition 10.2.0.4.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-12034 Error [message #461837]

Mon, 21 June 2010 14:34

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

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: ORA-12034 Error [message #461847 is a reply to message #461843]

Mon, 21 June 2010 16:20

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 06 13:55:30 CST 2025