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

ORA-14501: object is not partitioned

文档解释ORA-14501:objectisnotpartitionedCause:Tableorindexisnotpartitioned.Invalidsyntax.Action:Retrythecommandwithcorrectsyntax.ORA-14501错误是oracle数据库报出的表示无法操作一个没有分...

IT技术学习 ·2023-07-11

ORA-14104: RECOVERABLE/UNRECOVERABLE may not be specified for partitioned tables/indices

文档解释ORA-14104:RECOVERABLE/UNRECOVERABLEmaynotbespecifiedforpartitionedtables/indicesCause:CREATETABLE/INDEXstatementusedtocreateapartitionedtable/indexcontained...

IT技术学习 ·2023-07-11

ORA-14172: invalid ALTER TABLE EXCHANGE SUBPARTITION option

文档解释ORA-14172:invalidALTERTABLEEXCHANGESUBPARTITIONoptionCause:NameofthetabletobeEXCHANGEDhastobefollowedby[{INCLUDING|EXCLUDING}INDEX][{WITH|WITHOUT}VALIDATION...

IT技术学习 ·2023-07-11

ORA-14507: partition corrupt. all rows do not fall within partition bounds

文档解释ORA-14507:partitioncorrupt.allrowsdonotfallwithinpartitionboundsCause:Thepartitioncontainsrowswhichshouldreallybeinsomeotherpartition.Possiblyduetoanexchang...

IT技术学习 ·2023-07-11

ORA-14313: Value string does not exist in partition string

文档解释ORA-14313:ValuestringdoesnotexistinpartitionstringCause:OneofthelistvaluesintheSPLITPARTITIONorDROPVALUESstatementdoesnotexistinthepartitionAction:Removethe...

IT技术学习 ·2023-07-11

ORA-26021: index string.string partition string loaded successfully with string keys

文档解释ORA-26021:indexstring.stringpartitionstringloadedsuccessfullywithstringkeysCause:Partitionedindexinformationputtoloaderlogfile.Action:None.Informationalonly...

IT技术学习 ·2023-07-11

ORA-30074: GLOBAL partitioned index on TIME/TIMESTAMP WITH TIME ZONE not allowed

文档解释ORA-30074:GLOBALpartitionedindexonTIME/TIMESTAMPWITHTIMEZONEnotallowedCause:trytoGLOBALpartitionedindexonTIME/TIMESTAMPWITHTIMEZONE.Action:DonotGLOBALpartit...

IT技术学习 ·2023-07-11

ORA-08112: a composite partition may not be coalesced as a whole

文档解释ORA-08112:acompositepartitionmaynotbecoalescedasawholeCause:UserattemptedtocoalesceacompositepartitionAction:Coalescetheindexasubpartitionatatime(usingALTER...

IT技术学习 ·2023-07-11

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

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

IT技术学习 ·2023-07-11

ORA-14086: a partitioned index may not be rebuilt as a whole

文档解释ORA-14086:apartitionedindexmaynotberebuiltasawholeCause:UserattemptedtorebuildapartitionedindexusingALTERINDEXREBUILDstatement,whichisillegalAction:Rebuildt...

IT技术学习 ·2023-07-11

ORA-14175: a subpartition maintenance operation may not be combined with other operations

文档解释ORA-14175:asubpartitionmaintenanceoperationmaynotbecombinedwithotheroperationsCause:ALTERTABLEorALTERINDEXstatementattemptedtocombineasubpartitionmaintenanc...

IT技术学习 ·2023-07-11

ORA-14118: CHECK constraint mismatch in ALTER TABLE EXCHANGE PARTITION

文档解释ORA-14118:CHECKconstraintmismatchinALTERTABLEEXCHANGEPARTITIONCause:ThecorrespondingcolumnsinthetablesspecifiedintheALTERTABLEEXCHANGEPARTITIONstatementhave...

IT技术学习 ·2023-07-11

ORA-14108: illegal partition-extended table name syntax

文档解释ORA-14108:illegalpartition-extendedtablenamesyntaxCause:Partitiontobeaccessedmayonlybespecifiedusingitsname.Userattemptedtouseapartitionnumberorabindvariabl...

IT技术学习 ·2023-07-11

ORA-14756: Table is not partitioned by Interval method.

文档解释ORA-14756:TableisnotpartitionedbyIntervalmethod.Cause:ThetablewasnotpartitionedbyIntervalmethod.Action:ALTERTABLESETSTOREINisonlyvalidforIntervalpartitioned...

IT技术学习 ·2023-07-11

ORA-42021: partition cannot be redefined online because of incompatible row dependencies

文档解释ORA-42021:partitioncannotberedefinedonlinebecauseofincompatiblerowdependenciesCause:original/interimtablewascreatedwithrowdependencyandinterim/originaltable...

IT技术学习 ·2023-07-11