#Interim

ORA-42031: interim table cannot have a commit SCN-based MV log defined on it

文档解释ORA-42031:interimtablecannothaveacommitSCN-basedMVlogdefinedonitCause:AnattemptwasmadetouseaninterimtablewhichhadacommitSCN-basedmaterialzedviewlogdefinedon...

ORA-12093: invalid interim table “string”.”string”

文档解释ORA-12093:invalidinterimtable“string”.”string”Cause:Thetableisnottheinterimtableofthecorrespondingtabletobeonlineredefined.Action:Pa...

ORA-42024: interim table of an AQ table can not be a partitioned table

文档解释ORA-42024:interimtableofanAQtablecannotbeapartitionedtableCause:Anattemptwasmadetouseapartitionedtableasaninterimtable.Action:Ensurethattheinterimtableisnot...
IT技术学习 ·2023-07-23

ORA-42017: interim table of an AQ table should not be an AQ table

文档解释ORA-42017:interimtableofanAQtableshouldnotbeanAQtableCause:AnattemptwasmadetocreateanAQtableasaninterimtableofanonlineredefinedAQtable.Action:Ensurethatthei...
IT技术学习 ·2023-07-18

ORA-32330: invalid operation on online redefinition interim table “string”.”string”

文档解释ORA-32330:invalidoperationononlineredefinitioninterimtable“string”.”string”Cause:Aninvalidoperationwasperformedonaninterimtablewhich...

ORA-42033: interim table “string”.”string” cannot have Flashback Data Archive enabled

文档解释ORA-42033:interimtable“string”.”string”cannothaveFlashbackDataArchiveenabledCause:Anattemptwasmadetoredefineatablewithaninterimtable...

ORA-42020: partition cannot be redefined online because of unsupported type of interim table

文档解释ORA-42020:partitioncannotberedefinedonlinebecauseofunsupportedtypeofinterimtableCause:Anunsupportedtypeofinterimtablewasprovidedduringthepartitionredefiniti...

ORA-42013: interim table of an AQ IOT table should be an IOT table

文档解释ORA-42013:interimtableofanAQIOTtableshouldbeanIOTtableCause:Anattemptwasmadetocreateatablethatisnotanindex-organizedtable(IOT)astheinterimtableofanAQIOTtabl...
IT技术学习 ·2023-07-09

ORA-42019: partition cannot be redefined online because of incompatible partitioning of interim table

文档解释ORA-42019:partitioncannotberedefinedonlinebecauseofincompatiblepartitioningofinterimtableCause:bothoriginalandinterimtablesarepartitioned,ororiginaltableisc...

Provisional, Temporary 和Interim 的区别

1Provisional adj.临时的、暂时的、暂定的;n.临时邮票 强调在一定时期内暂时的、双方同意的但还不是最终确定的决定或者条约等。 Suchas例如:Provisionalgovernment临时政府(临时成立的政府,与interimgovernment意义相同)Provisio...