51
Dev开发社区
首页
文章
问答
工具
搜索
登录
注册
#Level
事务隔离级别(IsolationLevel)
事务的特性(ACID)1、原子性(Atomicity) 事物是数据库的逻辑工作单位,事务中的诸多操作要么全做要么全不做2、一致性(Consistency) 事务执行结果必须是使数据库从一个一致性状态变到另一个一致性状态3、隔离性(Isolation) 一个数据的执行不能被其他事务干扰4、持续性/永久性(Durab...
开发笔记
·
2024-09-02
事务
隔离
级别
IsolationLevel
ORA-30364: this level has the same set of columns as another
文档解释ORA-30364:thislevelhasthesamesetofcolumnsasanotherCause:Theleveldefinitioncontainedthesamesetofcolumnsasanotherlevel.Action:Eliminatetheredundantleveldefini...
IT技术学习
·
2023-07-28
ORA-30364
this
level
has
the
ORA-32335: dimension must have at least one level
文档解释ORA-32335:dimensionmusthaveatleastonelevelCause:Anlevel-lessdimensionisnotallowed.Action:Donotdroptheonlylevelofadimension.ORA-32335:dimensionmusthaveatleas...
IT技术学习
·
2023-07-28
ORA-32335
dimension
must
have
at
ORA-04077: WHEN clause cannot be used with table level triggers
文档解释ORA-04077:WHENclausecannotbeusedwithtableleveltriggersCause:Thewhenclausecanonlybespecifiedforrowleveltriggers.Action:Removethewhenclauseorspecifyforeachrow...
IT技术学习
·
2023-07-28
ORA-04077
WHEN
clause
cannot
be
ORA-54529: geometry should have multi-level hierarchy (like triangle)
文档解释ORA-54529:geometryshouldhavemulti-levelhierarchy(liketriangle)Cause:Thegeometrydidnothavethemulti-levelhierarchyrequiredforthisoperation.Forexample,ifthepar...
IT技术学习
·
2023-07-28
ORA-54529
geometry
should
have
multi-level
ORA-32037: unsupported use of LEVEL in membership condition
文档解释ORA-32037:unsupporteduseofLEVELinmembershipconditionCause:AnattemptwasmadetouseLEVELinmembershipconditionwithsubquerythatisnotsupported.Action:Rewritequeryt...
IT技术学习
·
2023-07-28
ORA-32037
unsupported
use
of
LEVEL
ORA-24760: invalid isolation level flags
文档解释ORA-24760:invalidisolationlevelflagsCause:Aninvalidisolationlevelflagwaspassed.Action:Verifythatonlyoneoffollowingvalues–OCI_TRANS_READONLY,OCI_TRANS_...
IT技术学习
·
2023-07-27
ORA-24760
invalid
isolation
level
flags
ORA-29472: DBMS_SQL.OPEN_CURSOR failed. security_level is outside the valid range of 0 to 2
文档解释ORA-29472:DBMS_SQL.OPEN_CURSORfailed.security_levelisoutsidethevalidrangeof0to2Cause:Aninvalidsecurity_levelvaluewasspecified.Action:Specifyavalidrangeof0to...
IT技术学习
·
2023-07-27
ORA-29472
DBMS
SQL.OPEN
CURSOR
failed.
ORA-53802: cannot perform conformance validation because recursion level exceeds MAX_RECURSION_DEPTH
文档解释ORA-53802:cannotperformconformancevalidationbecauserecursionlevelexceedsMAX_RECURSION_DEPTHCause:WhenevaluatingtherecursiveconstraintontheDICOMobject,thenum...
IT技术学习
·
2023-07-27
ORA-53802
cannot
perform
conformance
validation
ORA-32045: maximum level of recursion reached while executing recursive WITH query
文档解释ORA-32045:maximumlevelofrecursionreachedwhileexecutingrecursiveWITHqueryCause:ArecursiveWITHqueryreachedthemaximumlevelofrecursionspecifiedandwasstopped.Act...
IT技术学习
·
2023-07-26
ORA-32045
maximum
level
of
recursion
ORA-56706: The specified Resource Manager plan is a subplan and cannot be set as a top-level plan
文档解释ORA-56706:ThespecifiedResourceManagerplanisasubplanandcannotbesetasatop-levelplanCause:Anattemptwasmadetosetasubplanasatop-levelplan.Action:Donotattempttose...
IT技术学习
·
2023-07-26
plan
ORA-56706
The
specified
Resource
ORA-55208: Too many matching levels were found for the input data
文档解释ORA-55208:ToomanymatchinglevelswerefoundfortheinputdataCause:Necessaryfieldvaluesweremissing.Action:Addadditionalfieldvaluepairsthatarenecessarytodeterminea...
IT技术学习
·
2023-07-26
ORA-55208
Too
many
matching
levels
ORA-30337: multiple JOIN KEY clauses specified for the same parent level
文档解释ORA-30337:multipleJOINKEYclausesspecifiedforthesameparentlevelCause:MultipleJOINKEYclauseswerespecifiedforagivenparentlevelinadimensionhierarchy.Action:Matc...
IT技术学习
·
2023-07-26
ORA-30337
multiple
JOIN
KEY
clauses
ORA-23480: Column string is not a top-level column of “string”.”string”.
文档解释ORA-23480:Columnstringisnotatop-levelcolumnof“string”.”string”.Cause:Thecolumniseithernotatop-levelcolumnorisnotpresentinthetableorm...
IT技术学习
·
2023-07-26
#8221.
ORA-23480
Column
string
is
ORA-13042: invalid SDO_LEVEL and SDO_NUMTILES combination
文档解释ORA-13042:invalidSDO_LEVELandSDO_NUMTILEScombinationCause:AninvalidcombinationofSDO_LEVELandSDO_NUMTILESvalueswasreadfromthe_SDOLAYERtable.Themostlikelycaus...
IT技术学习
·
2023-07-26
SDO
ORA-13042
invalid
LEVEL
and
首页
上一页
1
2
3
4
5
...
下一页
尾页
按字母分类:
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
其他