Home » SQL & PL/SQL » SQL & PL/SQL » ora 12034 view log is younger than last refresh
ora 12034 view log is younger than last refresh [message #419448] Sat, 22 August 2009 08:31 Go to next message
webdino73
Messages: 15
Registered: August 2005
Junior Member
I have a materialized view and a log that produces the error ora 12034

I have tried to drop and recreate but there is no change in error what oracle says.
Then I tried to refresh complete
EXECUTE DBMS_MVIEW.REFRESH('VM_IS_CALC','C')

But also there is no change in the shown error.
I can not see the error to synchronize the Log with the view
especially I will prevent that this error came in future.

Has anyone help? Thank you












Create Skript is:
CREATE MATERIALIZED VIEW LOG ON IS_TABLE
TABLESPACE USERS
PCTUSED 0
PCTFREE 60
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
)
NOCACHE
NOPARALLEL
WITH ROWID;

CREATE MATERIALIZED VIEW LOG ON IS_TABLE1
TABLESPACE USERS
PCTUSED 0
PCTFREE 60
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
)
NOCACHE
NOPARALLEL
WITH ROWID;
CREATE MATERIALIZED VIEW VM_IS_CALC
TABLESPACE USERS
NOCACHE
LOGGING
NOPARALLEL
REFRESH FORCE
REFRESH FAST ON COMMIT
ENABLE QUERY REWRITE
AS
SELECT I.ROWID RID_I
,ZKTO.ROWID RID_ZKTO
,ZKST.ROWID RID_ZKST
FROM
IS_ZEILE I,
IS_TABLE1 ZKTO,
IS_TABLE ZKST
WHERE I.IS_ZEILE_NR = ZKTO.IS_ZEILE_NR
AND I.IS_ZEILE_NR = ZKST.IS_ZEILE_NR;

CREATE INDEX IDX_VM_IS_PAT ON VM_IS_CALC
(....)
LOGGING
TABLESPACE USERS
NOPARALLEL;
Re: ora 12034 view log is younger than last refresh [message #419449 is a reply to message #419448] Sat, 22 August 2009 08:56 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.

12034, 0000, "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.
//
Re: ora 12034 view log is younger than last refresh [message #419452 is a reply to message #419449] Sat, 22 August 2009 09:24 Go to previous messageGo to next message
webdino73
Messages: 15
Registered: August 2005
Junior Member
sorry I will do this at my next Post


But your note does not help me with my problem. Complete refresh has no effect
Re: ora 12034 view log is younger than last refresh [message #419453 is a reply to message #419448] Sat, 22 August 2009 09:31 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>Complete refresh has no effect
If error is incorrectly reported, then open Service Request & file bug with Oracle.

We don't know OS name or version.
We don't know Oracle version (to 4 decimal places)
We don't have DML for test data.
We can not reproduce what you report.
No assistance is possible at this time.
Re: ora 12034 view log is younger than last refresh [message #419496 is a reply to message #419453] Sun, 23 August 2009 05:39 Go to previous messageGo to next message
webdino73
Messages: 15
Registered: August 2005
Junior Member
OS: windows 2003 Server
Oracle V: 9.2.0.1

I ask for help, there are thousends of data sets in the table. I think I shouldn´t post them here..
I ask if someone has a tip where the error came from because drop, recreate and Complete refresh of the MV has no result.

Re: ora 12034 view log is younger than last refresh [message #419503 is a reply to message #419448] Sun, 23 August 2009 11:05 Go to previous message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>OS: windows 2003 Server
>Oracle V: 9.2.0.1
V9 is obsoleted & unsupported and never certified on Windows 2003.
You should be patched up to V9.0.2.8 at a minimum
When was the last time this worked in this environment & what changed?
I no longer have any V9 systems upon which I could test.
Sorry that I can't assist more
Previous Topic: send email with attachement (merged 3)
Next Topic: ORA-06530: Reference to uninitialized composite
Goto Forum:
  


Current Time: Thu Dec 08 14:32:44 CST 2016

Total time taken to generate the page: 0.24032 seconds