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

ORA-14279: index mismatch for tables in ALTER TABLE EXCHANGE SUBPARTITION

文档解释ORA-14279:indexmismatchfortablesinALTERTABLEEXCHANGESUBPARTITIONCause:ThetwotablesspecifiedintheALTERTABLEEXCHANGESUBPARTITIONhaveindexeswhicharenotequivale...

IT技术学习 ·2023-07-16

ORA-39924: Default Composite Partition (Index) Tablespace string for string not contained in transportable set.

文档解释ORA-39924:DefaultCompositePartition(Index)Tablespacestringforstringnotcontainedintransportableset.Cause:Informationalmessagetodescribeafailureduringtranspor...

IT技术学习 ·2023-07-16

ORA-39909: Index string.string in tablespace string points to table/cluster string.string in tablespace string.

文档解释ORA-39909:Indexstring.stringintablespacestringpointstotable/clusterstring.stringintablespacestring.Cause:Informationalmessagetodescribeafailureduringtranspo...

IT技术学习 ·2023-07-16

ORA-14642: Bitmap index mismatch for tables in ALTER TABLE EXCHANGE PARTITION

文档解释ORA-14642:BitmapindexmismatchfortablesinALTERTABLEEXCHANGEPARTITIONCause:ThetwotablesintheEXCHANGEhaveusablebitmapindexes,andtheINCLUDINGINDEXESoptionhasbee...

IT技术学习 ·2023-07-16

ORA-13501: Cannot drop SYSAUX tablespace

文档解释ORA-13501:CannotdropSYSAUXtablespaceCause:TriedtodropSYSAUXtablespaceAction:NoneORA-13501代表一条非法的SQL语句，必须停止执行。它表明尝试删除SYSAUX表空间，这是不可能的。SYSAUX表空间是Oracle数据库自动创建...

IT技术学习 ·2023-07-16

ORA-14310: VALUES LESS THAN or AT clause cannot be used with List partitioned tables

文档解释ORA-14310:VALUESLESSTHANorATclausecannotbeusedwithListpartitionedtablesCause:VALUESLESSTHANorATclausecanbeusedonlywithRangepartitionedtablesAction:UseVALUES...

IT技术学习 ·2023-07-13

ORA-29346: invalid tablespace list

文档解释ORA-29346:invalidtablespacelistCause:thetablespacelistsuppliedtodbms_tts.transport_set_checkPL/SQLroutineisinanincorrectformat.Action:Checkthemanualanduseth...

IT技术学习 ·2023-07-13

ORA-14704: Create table as select disallowed for SYSTEM patitioned tables

文档解释ORA-14704:CreatetableasselectdisallowedforSYSTEMpatitionedtablesCause:UserattemptedtocreateaSYSTEMpartitionedtablebydoingacreatetableasselect.Action:Doacrea...

IT技术学习 ·2023-07-13

ORA-39803: Data saves are not allowed on tables with partitioning referential constraints.

文档解释ORA-39803:Datasavesarenotallowedontableswithpartitioningreferentialconstraints.Cause:Datasaves(andthesqlldrROWSparameter)arenotallowedwhenloadingboththepare...

IT技术学习 ·2023-07-13

ORA-30029: no active undo tablespace assigned to instance

文档解释ORA-30029:noactiveundotablespaceassignedtoinstanceCause:thecurrentinstancedoesnothaveanactiveundotablespaceassignedtoexecutetransactions.Action:askDBAtocrea...

IT技术学习 ·2023-07-13

ORA-42302: definition of an Editioning view may not refer to remote tables

文档解释ORA-42302:definitionofanEditioningviewmaynotrefertoremotetablesCause:AnattemptwasmadetocreateanEditioningviewreferringtoremotetables,whichisnotsupported.Act...

IT技术学习 ·2023-07-13

ORA-26794: Hierarchically enabled tables not supported

文档解释ORA-26794:HierarchicallyenabledtablesnotsupportedCause:Hierarchicallyenabledtablesarenotsupported.Action:Disablehierarchyforthetable.ORA-26794错误是由于Oracle数据库...

IT技术学习 ·2023-07-13

ORA-12919: Can not drop the default permanent tablespace

文档解释ORA-12919:CannotdropthedefaultpermanenttablespaceCause:AnattempwasmadetodropthedefaultpermanenttablespaceAction:Makeadifferenttablespaceasthedefaultpermanen...

IT技术学习 ·2023-07-13

ORA-54641: PARTITION_TABLE utility: scratch tables exist with oidstr = string

文档解释ORA-54641:PARTITION_TABLEutility:scratchtablesexistwithoidstr=stringCause:Scratchtables/viewscouldnotbecreatedbecausetheyalreadyexisted.Action:UseSDO_UTIL.D...

IT技术学习 ·2023-07-13

ORA-28602: statement not permitted on tables containing bitmap indexes

文档解释ORA-28602:statementnotpermittedontablescontainingbitmapindexesCause:tablehasbitmapindexesanduserisminimizingornominimizingrecords_per_blockAction:dropallbit...

IT技术学习 ·2023-07-11