#SYSAUX

ORA-13503: Creating SYSAUX tablespace with invalid attributes

文档解释ORA-13503:CreatingSYSAUXtablespacewithinvalidattributesCause:AnattempttocreatetheSYSAUXtablespacewithinvalidattributes.Action:CreateSYSAUXtablespacewithONLI...

ORA-13500: SYSAUX DATAFILE clause specified more than once

文档解释ORA-13500:SYSAUXDATAFILEclausespecifiedmorethanonceCause:TheCREATEDATABASEcommandcontainsmorethanoneSYSAUXDATAFILEclause.Action:SpecifyatmostoneSYSAUXDATAFI...

ORA-13502: Cannot rename SYSAUX tablespace

文档解释ORA-13502:CannotrenameSYSAUXtablespaceCause:AnattempttorenametheSYSAUXtablespacefailed.Action:Noactionrequired.官方解释ORA-13502出现,说明无法重命名SYSAUX表空间。这个错误提示表示在重命名...

ORA-10648: Tablespace SYSAUX is not offline

文档解释ORA-10648:TablespaceSYSAUXisnotofflineCause:TheSYSAUXtablespacewasonlinewhileSYSTEMtablespacewasbeingmigrated.Action:AltertheSYSAUXtablespacestatustooffline...

ORA-13505: SYSAUX tablespace can not be made read only

文档解释ORA-13505:SYSAUXtablespacecannotbemadereadonlyCause:AttemptingtosettheSYSAUXtablespacetoreadonly.TheSYSAUXtablespacemustremainreadwritefordatabaseoperation....

ORA-13501: Cannot drop SYSAUX tablespace

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

ORA-13504: No SYSAUX datafile clause specified

文档解释ORA-13504:NoSYSAUXdatafileclausespecifiedCause:IfCreateDatabasehasthedatafileclause,thenSYSAUXdatafileclausehastobespecified,unlessusingOMF.Action:Specifyth...

ORA-13913: The threshold cannot be set when SYSAUX is offline.

文档解释ORA-13913:ThethresholdcannotbesetwhenSYSAUXisoffline.Cause:SET_THRESHOLDprocedurewascalledwhenSYSAUXtablespacewasoffline.Action:CallSET_THRESHOLDprocedurewh...

ORA-13525: error with computing space usage for sysaux occupant

文档解释ORA-13525:errorwithcomputingspaceusageforsysauxoccupantCause:ErroroccurredduringOCIoperationduetounderlyingerror.Action:CheckassociatedOCIerror.Correctprobl...

清理sysaux

--sysauxSELECToccupant_name,schema_name,(space_usage_kbytes/1024)MFROMv$sysaux_occupantsORDERBY3;selectSNAP_ID,BEGIN_INTERVAL_TIMEfromdba_hist_snapshotorderby2;...
开发笔记 开发笔记·2020-03-17