OraFAQ Forum: Replication » Can't refresh Materialized View

Home » Server Options » Replication » Can't refresh Materialized View

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

Can't refresh Materialized View [message #283669]

Tue, 27 November 2007 22:42

mahendraabc
Messages: 12
Registered: October 2000

Junior Member

Hi,
I've created Materialized View from a view and trying to refresh periodically with the following script

CREATE MATERIALIZED VIEW schema1.MV_XXXX
PCTFREE 10 PCTUSED 0 INITRANS 2 MAXTRANS 255
STORAGE( INITIAL 64 K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT )
TABLESPACE YYYYY
LOGGING
NOCACHE
NOPARALLEL
USING
INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE( BUFFER_POOL DEFAULT )
REFRESH
FORCE ON DEMAND
START WITH TO_DATE( '27-NOV-2007 15:03:51','dd-mon-yyyy hh24:mi:ss')
NEXT SYSDATE + 19/24
WITH ROWID
USING DEFAULT LOCAL ROLLBACK SEGMENT
DISABLE
QUERY REWRITE AS
SELECT * FROM schema2.VW_yyyy

Report message to a moderator

Re: Can't refresh Materialized View [message #283670 is a reply to message #283669]

Tue, 27 November 2007 22:45

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

I can't make my car to go.

If you'll solve my problem, then I'll solve your problem.

Report message to a moderator

Re: Can't refresh Materialized View [message #283698 is a reply to message #283669]

Wed, 28 November 2007 00:19

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

Senior Member
Account Moderator

And?

Regards
Michel

Report message to a moderator

Re: Can't refresh Materialized View [message #283764 is a reply to message #283669]

Wed, 28 November 2007 01:52

martijn
Messages: 286
Registered: December 2006
Location: Netherlands

Senior Member

PLease send some more information:
- Oracle version
- error messages
- .....

At the moment it's a bit hard to guess what's going wrong.

Best regards,
Martijn

Report message to a moderator

Re: Can't refresh Materialized View [message #284674 is a reply to message #283669]

Fri, 30 November 2007 08:44

skooman
Messages: 913
Registered: March 2005
Location: Netherlands

Senior Member

Quote:

trying to refresh periodically with the following script

Well, for one thing you say you refresh it and the script you show is a create script...

Report message to a moderator

Previous Topic:	ORA-26563: renaming this table is not allowed
Next Topic:	multimaster replication blocked

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 30 11:57:55 CST 2025