#fresh

ORA-30450: refresh_after_errors was TRUE; The following MVs could not be refreshed: string

文档解释ORA-30450:refresh_after_errorswasTRUE;ThefollowingMVscouldnotberefreshed:stringCause:Oneormoreerrorsoccurredduringarefreshofmultiplesummaries.Action:Thenumb...

ORA-23409: could not find an unused refresh group number

文档解释ORA-23409:couldnotfindanunusedrefreshgroupnumberCause:1000consecutiverefreshgroupnumbers,asdefinedbythergroupseqnumber,werealreadyusedbyrowsinsys.rgroup$.Ac...
IT技术学习 ·2023-07-16

ORA-21709: cannot refresh an object that has been modified

文档解释ORA-21709:cannotrefreshanobjectthathasbeenmodifiedCause:Userattemptedtorefreshanobjectthathasbeenmarkedfordelete,updateorinsert(new).Action:Usershouldunmark...

ORA-23442: object already exists for the refresh group template

文档解释ORA-23442:objectalreadyexistsfortherefreshgrouptemplateCause:Thespecifiedobjectalreadyexistsintherefreshgrouptemplate.Action:Changetheobjectnameandobjecttyp...

ORA-32320: REFRESH FAST of “string”.”string” unsupported after container table PMOPs

文档解释ORA-32320:REFRESHFASTof“string”.”string”unsupportedaftercontainertablePMOPsCause:APartitionMaintenanceOperation(PMOP)hasbeenperforme...

ORA-32345: fail to refresh the materialized view string.string due to the changed synonym

文档解释ORA-32345:failtorefreshthematerializedviewstring.stringduetothechangedsynonymCause:Thedefinitionofoneormoresynonymsinthefromclausehavechanged.Thestructureof...
IT技术学习 ·2023-07-11

ORA-30374: materialized view is already fresh

文档解释ORA-30374:materializedviewisalreadyfreshCause:Ifthematerializedviewisfresh,ORACLEignorestheALTERMATERIALIZEDVIEWRELYFRESHcommand,andissuesthiserrormessage.A...

ORA-12015: cannot create a fast refresh materialized view from a complex query

文档解释ORA-12015:cannotcreateafastrefreshmaterializedviewfromacomplexqueryCause:NeitherROWIDsandnorprimarykeyconstraintsaresupportedforcomplexqueries.Action:Reissu...

ORA-32322: PCT refresh of “string”.”string” not allowed the sequence of DMLs/PMOPs

文档解释ORA-32322:PCTrefreshof“string”.”string”notallowedthesequenceofDMLs/PMOPsCause:AtablejoindependentonanothertableonwhichPCTrefreshisen...

ORA-30356: the specified refresh method is not supported in this context

文档解释ORA-30356:thespecifiedrefreshmethodisnotsupportedinthiscontextCause:Therefreshmethodthatwasspecifiedisnotcurrentlysupported.Action:Specifyadifferentrefreshm...

ORA-23438: missing refresh group template

文档解释ORA-23438:missingrefreshgrouptemplateCause:Thespecifiedrefreshgrouptemplatedoesnotexist.Action:VerifythattherefreshgrouptemplatedoesnotexistbyqueryingtheDBA...

ORA-12013: updatable materialized views must be simple enough to do fast refresh

文档解释ORA-12013:updatablematerializedviewsmustbesimpleenoughtodofastrefreshCause:Theupdatablematerializedviewquerycontainedajoin,subquery,union,connectby,orderby,...

ORA-12036: updatable materialized view log is not empty, refresh materialized view

文档解释ORA-12036:updatablematerializedviewlogisnotempty,refreshmaterializedviewCause:Theupdatablematerializedviewlogwasnotempty.Theupdatablematerializedviewlogmust...

ORA-12056: invalid REFRESH method

文档解释ORA-12056:invalidREFRESHmethodCause:TheNEVERREFRESHoptionmaynotbeusedunderthefollowingconditions:*Thematerializedviewisupdatable*Thematerializedviewrefreshe...
IT技术学习 ·2023-07-10

ORA-32315: REFRESH FAST of “string”.”string” unsupported after mixed DML and Direct Load

文档解释ORA-32315:REFRESHFASTof“string”.”string”unsupportedaftermixedDMLandDirectLoadCause:Oneormoreofthematerializedviewlogsonthedetailtabl...
首页上一页12345...下一页尾页