OraFAQ Forum: SQL & PL/SQL » Materialized Views Cannot set with refresh Fast "Error"

Home » SQL & PL/SQL » SQL & PL/SQL » Materialized Views Cannot set with refresh Fast "Error" (Oracle 19)

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

Materialized Views Cannot set with refresh Fast "Error" [message #678503]

Mon, 09 December 2019 10:55

greatwhite
Messages: 3
Registered: December 2019

Junior Member

I am / was attempting to modified a Materialized View. I dropped the view and recreated it after I altered the SQL. However I could not recreate it with Refresh Fast so I set it to Force for the interim.
Now I am trying to change it to Fast and I keep getting the error ORA-23413 (I have attached a snap shot of the complete message.

I don't understand why I am getting this message as the Log still exists.

/forum/index.ph/forum/fa/14234/0/

Attachment: Capture.JPG
(Size: 31.78KB, Downloaded 1742 times)

Report message to a moderator

Re: Materialized Views Cannot set with refresh Fast "Error" [message #678505 is a reply to message #678503]

Mon, 09 December 2019 11:37

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

Senior Member
Account Moderator

Quote:

I don't understand why I am getting this message as the Log still exists.

Either you are wrong either there is an Oracle bug, in both case we can't do anything.
Double-check you actually have a materialized log and on the correct table.

Report message to a moderator

Re: Materialized Views Cannot set with refresh Fast "Error" [message #678506 is a reply to message #678505]

Mon, 09 December 2019 12:40

greatwhite
Messages: 3
Registered: December 2019

Junior Member

OK so I created a new Log/

Create Materialized View Log on "EE"."MV_DP_EE_table" WITH ROWID

Than I executed a refresh on the Materialized view and I can see data in the log.

Than I tried to change the refresh method and I get the exact same error.

Report message to a moderator

Re: Materialized Views Cannot set with refresh Fast "Error" [message #678507 is a reply to message #678506]

Mon, 09 December 2019 14:55

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

Senior Member
Account Moderator

If you say so.
As you don't show us what you do and get, that is copy and paste your SQL*Plus (before, Please read How to use [code] tags and make your code easier to read), we can't tell anything about what is or is not wrong.

Report message to a moderator

Re: Materialized Views Cannot set with refresh Fast "Error" [message #678508 is a reply to message #678506]

Mon, 09 December 2019 15:33

John Watson
Messages: 8997
Registered: January 2010
Location: Global Village

Senior Member

What is the statement used to create the MV?

Report message to a moderator

Re: Materialized Views Cannot set with refresh Fast "Error" [message #678509 is a reply to message #678503]

Mon, 09 December 2019 15:59

Solomon Yakobson
Messages: 3305
Registered: January 2010
Location: Connecticut, USA

Senior Member

So you decided no drop complete refresh MV and create fast refresh MV with same underlying query and got an error. Did you even read error message???? Which part of "doesn't have materialized view log" you don't understand? Did you even read on what fast refresh is and how it works?

SY.

Report message to a moderator

Re: Materialized Views Cannot set with refresh Fast "Error" [message #678510 is a reply to message #678509]

Mon, 09 December 2019 16:42

greatwhite
Messages: 3
Registered: December 2019

Junior Member

Wow first time I have ever experienced such a rude comment on a forum asking a simple question. If I knew everything about Materialized Views I probably would not have asked.

Luckily I figured out what I was doing wrong. But definitely no help from this site. Feel free to close my account.

Wow just wow

Report message to a moderator