REFRESH主题的文章列表，还有REFRESH的技术要点_第2页

ORA-12057: materialized view “string”.”string” is INVALID and must complete refresh

文档解释ORA-12057:materializedview“string”.”string”isINVALIDandmustcompleterefreshCause:ThestatusofthematerializedviewwasINVALIDandanattempt...

IT技术学习 ·2023-07-19

ORA-32316: REFRESH FAST of “string”.”string” unsupported after mixed DML

文档解释ORA-32316:REFRESHFASTof“string”.”string”unsupportedaftermixedDMLCause:Oneormoreofthematerializedviewlogsonthedetailtablesreferencedb...

IT技术学习 ·2023-07-19

ORA-32337: cannot alter materialized view with pending changes refresh on commit

文档解释ORA-32337:cannotaltermaterializedviewwithpendingchangesrefreshoncommitCause:TherearesomependingchangesinthedetailtablesAction:Executeanon-demandrefreshonthe...

IT技术学习 ·2023-07-19

ORA-09218: sfrfs: failed to refresh file size

文档解释ORA-09218:sfrfs:failedtorefreshfilesizeCause:FilemaybecorruptedortruncatedAction:SeeOSDerroraccompanyingthismessageORA-09218：sfrfs：无法刷新文件大小官方解释ORA-09218表明无法...

IT技术学习 ·2023-07-19

ORA-12008: error in materialized view refresh path

文档解释ORA-12008:errorinmaterializedviewrefreshpathCause:TableSNAP$_readsrowsfromtheviewMVIEW$_,whichisaviewonthemastertable(themastermaybeataremotesite).Anyerrori...

IT技术学习 ·2023-07-19

ORA-32346: ON COMMIT materialized view refresh caused changes to the master table/materialized view

文档解释ORA-32346:ONCOMMITmaterializedviewrefreshcausedchangestothemastertable/materializedviewCause:ONCOMMITrefreshofaread-onlymaterializedviewchangedthemastertabl...

IT技术学习 ·2023-07-19

ORA-23439: refresh group template already exists

文档解释ORA-23439:refreshgrouptemplatealreadyexistsCause:Thespecifiedrefreshgrouptemplatealreadyexists.Action:VerifythattherefreshgrouptemplateexistsbyqueryingtheDB...

IT技术学习 ·2023-07-19

ORA-12047: PCT FAST REFRESH cannot be used for materialized view “string”.”string”

文档解释ORA-12047:PCTFASTREFRESHcannotbeusedformaterializedview“string”.”string”Cause:PCTrefreshiseithernotenabledonthismaterializedvieworno...

IT技术学习 ·2023-07-17

ORA-32350: ON COMMIT refresh obtain shared lock for all the detailed tables

文档解释ORA-32350:ONCOMMITrefreshobtainsharedlockforallthedetailedtablesCause:AneventwassettoletONCOMMITmaterializedviewrefreshtoobtainasharedlockforallthedetailedt...

IT技术学习 ·2023-07-17

ORA-26530: unable to build materialized view refresh control list

文档解释ORA-26530:unabletobuildmaterializedviewrefreshcontrollistCause:Thematerializedviewcontrollistcouldnotbeconstructed.Thisisgenerallytheresultofanerrorwhileacc...

IT技术学习 ·2023-07-17

ORA-12078: fast refresh of refresh group ID string failed

文档解释ORA-12078:fastrefreshofrefreshgroupIDstringfailedCause:RefreshresultsetsentthroughclientmethodREFRESH_REQ_RESULTreturnedanunknownvalue.Action:Re-issuetheref...

IT技术学习 ·2023-07-16

ORA-23441: object does not exist for refresh group template

文档解释ORA-23441:objectdoesnotexistforrefreshgrouptemplateCause:Thespecifiedobjectdoesnotexistintherefreshgrouptemplate.Action:Correcttheobjectnameandobjecttypepar...

IT技术学习 ·2023-07-16

ORA-12004: REFRESH FAST cannot be used for materialized view “string”.”string”

文档解释ORA-12004:REFRESHFASTcannotbeusedformaterializedview“string”.”string”Cause:Thematerializedviewlogdoesnotexistorcannotbeused.PCTrefre...

IT技术学习 ·2023-07-16

ORA-32338: on commit refresh grab all the detailed tables

文档解释ORA-32338:oncommitrefreshgraballthedetailedtablesCause:aneventissettoleton-commitMVrefreshtograballthedetailedtables,nomatterwhethertheyhavemodifiedornot.Ac...

IT技术学习 ·2023-07-16

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...

IT技术学习 ·2023-07-16