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

ORA-10634: Segment is already being shrunk

文档解释ORA-10634:SegmentisalreadybeingshrunkCause:OnlyoneinvocationofshrinkcanbeinprogressonasegmentatanytimeAction:ReissuethecommandafterthefirstshrinkisoverORA-1...

IT技术学习·2023-07-26

ORA-10658: Lob column to be shrunk is marked unused

文档解释ORA-10658:LobcolumntobeshrunkismarkedunusedCause:ShrinkwasissuedonalobsegmentthatismarkedasunusedAction:NoneORA-10658的错误消息表示要收缩的lob字段已被标记为未使用，这会导致数据库操作失败。官方...

IT技术学习·2023-07-26

ORA-19567: cannot shrink file string because it is being backed up or copied

文档解释ORA-19567:cannotshrinkfilestringbecauseitisbeingbackeduporcopiedCause:AnALTERstatementattemptedtoreducethesizeoftheindicatedfilewhilethesamefileisbeingbacke...

IT技术学习·2023-07-26

ORA-10631: SHRINK clause should not be specified for this object

文档解释ORA-10631:SHRINKclauseshouldnotbespecifiedforthisobjectCause:ItisincorrecttoissueshrinkontheobjectAction:Verifytheobjectnameandtypeandreissuethecommand：ORA-...

IT技术学习·2023-07-19

ORA-38884: Cannot shrink data file string on standby database due to guaranteed restore points.

文档解释ORA-38884:Cannotshrinkdatafilestringonstandbydatabaseduetoguaranteedrestorepoints.Cause:Anattemptwasmadetoshrinkadatafileonastandbydatabasewhilethereareguar...

IT技术学习·2023-07-19

ORA-10655: Segment can be shrunk

文档解释ORA-10655:SegmentcanbeshrunkCause:ErrormessagereturnedwhencalledinprobemodebyOEMAction:NoneORA-10655是一个段缩小错误，当引擎试图从一个段中删除数据，而该段没有得到正确的支持时，它会发生。官方解释ORA-10655...

IT技术学习·2023-07-19

ORA-10630: Illegal syntax specified with SHRINK clause

文档解释ORA-10630:IllegalsyntaxspecifiedwithSHRINKclauseCause:AnillegaloptionwasspecifiedwiththeSHRINKclauseAction:VerifytheSQLReferenceManualandreissuethecommandOR...

IT技术学习·2023-07-17

ORA-12916: cannot shrink permanent or dictionary managed tablespace

文档解释ORA-12916:cannotshrinkpermanentordictionarymanagedtablespaceCause:Anattemptwasmadetoshrinkapermanenttablespaceoradictionarymanagedtablespace.Action:Checkthe...

IT技术学习·2023-07-11

ORA-38883: Cannot shrink data file string on primary database due to guaranteed restore points.

文档解释ORA-38883:Cannotshrinkdatafilestringonprimarydatabaseduetoguaranteedrestorepoints.Cause:Anattemptwasmadetoshrinkadatafileonaprimarydatabasewhilethereareguar...

IT技术学习·2023-07-10

ORA-10657: Lob column to be shrunk does not exist

文档解释ORA-10657:LobcolumntobeshrunkdoesnotexistCause:ShrinkwasissuedonalobsegmentthatdidnotexistAction:NoneORA-10657：该错误消息指出，当用户尝试使用ALTERTABLE语句来缩减LoB字段内容时，制定的等待缩...

IT技术学习·2023-07-10

ORA-00846: could not shrink MEMORY_TARGET to specified value

文档解释ORA-00846:couldnotshrinkMEMORY_TARGETtospecifiedvalueCause:AttemptedtoshrinkMEMORY_TARGETtothespecifiedvaluebutdidnotsucceedbecausethePGAandSGAcomponentscou...

IT技术学习·2023-07-09

ORA-01657: invalid SHRINK option value

文档解释ORA-01657:invalidSHRINKoptionvalueCause:Thespecifiedvaluemustbeaninteger.Action:Chooseanappropriateintegervalue.这是一个Oracle数据库的错误代码，其中ORA-01657:invalidSHRINK...

IT技术学习·2023-07-08

ORA-03298: cannot shrink datafile – file string is under hot backup

文档解释ORA-03298:cannotshrinkdatafile–filestringisunderhotbackupCause:Attempttoshrinkadatafilewhileitisunderhotbackup.Thisisnotallowed.Action:Retryshrinkingt...

IT技术学习·2023-07-08

ORA-01238: cannot shrink datafile string

文档解释ORA-01238:cannotshrinkdatafilestringCause:Anoperatingsystemerroroccurredduringtheresize.Action:Theerrorisignored,operationcontinuesnormally.这是Oracle数据库中发生的一...

IT技术学习·2023-07-08

ORA-00827: could not shrink sga_target to specified value

文档解释ORA-00827:couldnotshrinksga_targettospecifiedvalueCause:AttemptedtoshrinktheSGAtothespecifiedvaluebutdidnotsucceedbecausetheSGAcomponentscouldnotbeshrunkast...

IT技术学习·2023-07-08