Home » Server Options » Replication » Can't refresh Materialized View
Can't refresh Materialized View [message #283669] Tue, 27 November 2007 22:42 Go to next message
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



Re: Can't refresh Materialized View [message #283670 is a reply to message #283669] Tue, 27 November 2007 22:45 Go to previous messageGo to next message
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.
Re: Can't refresh Materialized View [message #283698 is a reply to message #283669] Wed, 28 November 2007 00:19 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And?

Regards
Michel
Re: Can't refresh Materialized View [message #283764 is a reply to message #283669] Wed, 28 November 2007 01:52 Go to previous messageGo to next message
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
Re: Can't refresh Materialized View [message #284674 is a reply to message #283669] Fri, 30 November 2007 08:44 Go to previous message
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...
Previous Topic: ORA-26563: renaming this table is not allowed
Next Topic: multimaster replication blocked
Goto Forum:
  


Current Time: Thu Mar 28 10:31:49 CDT 2024