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

Oracle 列信息查询详解(dba_tab_columns、dba_tab_cols)

1概述1.1.作用：描述table、view中'列的定义信息'(1)数据类型、精度、是否为空等等1.2.dba_tab_columns和dba_tab_cols区别(1)两者都查询列的定义信息--相同点(2)dba_tab_cols中包含Oracle的'隐藏列'(hiddencolumn)范围>=dba_tab_...

开发笔记 ·2025-02-04

ORA-26846: Found “string” active automatic merge jobs for cloned string Capture “string” in DBA_STREAMS_SPLIT_MERGE

文档解释ORA-26846:Found“string”activeautomaticmergejobsforclonedstringCapture“string”inDBA_STREAMS_SPLIT_MERGECause:Onlyoneactivemergejobisa...

IT技术学习 ·2023-07-28

ORA-09330: Session terminated internally by Oracle or by an Oracle DBA

文档解释ORA-09330:SessionterminatedinternallybyOracleorbyanOracleDBACause:Oracletoterminatethatsessionafteraboutaminute.Thismessagealsoappearsinthetracefileifashutd...

IT技术学习 ·2023-07-26

ORA-25161: Cannot have both DBA and RDBA options

文档解释ORA-25161:CannothavebothDBAandRDBAoptionsCause:BoththeDBAandRDBAoptionswerepassedtoALTERSYSTEMDUMPREDO.Action:UseeithertheDBAoptionortheRDBAoptionbutnotboth...

IT技术学习 ·2023-07-26

ORA-26863: Job “string” showing as an active job in DBA_STREAMS_SPLIT_MERGE does not exist in DBA_SCHEDULER_JOBS.

文档解释ORA-26863:Job“string”showingasanactivejobinDBA_STREAMS_SPLIT_MERGEdoesnotexistinDBA_SCHEDULER_JOBS.Cause:AnactivejobshowinginDBA_STREAMS_SPLIT_M...

IT技术学习 ·2023-07-26

ORA-26844: Found “string” active automatic split jobs for string Capture “string” in DBA_STREAMS_SPLIT_MERGE

文档解释ORA-26844:Found“string”activeautomaticsplitjobsforstringCapture“string”inDBA_STREAMS_SPLIT_MERGECause:Onlyoneactivesplitjobisallowed...

IT技术学习 ·2023-07-26

ORA-31534: Change Data Capture string publisher string is missing DBA role

文档解释ORA-31534:ChangeDataCapturestringpublisherstringismissingDBAroleCause:ThepublisherdoesnothavetheDBArole,whichisrequiredbytheChangeDataCaptureoperation.Actio...

IT技术学习 ·2023-07-25

ORA-13842: no SELECT privilege on DBA_SQL_PROFILES

文档解释ORA-13842:noSELECTprivilegeonDBA_SQL_PROFILESCause:AuserhastriedtoperformanoperationthatrequiresSELECTprivilegesontheDBA_SQL_PROFILESview.Action:Eitherperfo...

IT技术学习 ·2023-07-22

ORA-09275: CONNECT INTERNAL is not a valid DBA connection

文档解释ORA-09275:CONNECTINTERNALisnotavalidDBAconnectionCause:CONNECTINTERNALisnolongersupportedforDBAconnections.Action:PleasetrytoconnectASSYSDBAorASSYSOPER.ORA-...

IT技术学习 ·2023-07-19

ORA-39710: only connect AS SYSDBA is allowed when OPEN in UPGRADE mode

文档解释ORA-39710:onlyconnectASSYSDBAisallowedwhenOPENinUPGRADEmodeCause:AnattemptwasmadetoconnecttoadatabasewhenthedatabasewasOPENforUPGRADEorDOWNGRADE.Action:Tryt...

IT技术学习 ·2025-02-20

ORA-28009: connection as SYS should be as SYSDBA or SYSOPER

文档解释ORA-28009:connectionasSYSshouldbeasSYSDBAorSYSOPERCause:connectSYS/isnolongeravalidsyntaxAction:TryconnectSYS/asSYSDBAorconnectSYS/asSYSOPERORA-28009：连接为SYS...

IT技术学习 ·2023-07-16

ORA-24428: Sessions with SYSDBA privileges are not supported in this mode.

文档解释ORA-24428:SessionswithSYSDBAprivilegesarenotsupportedinthismode.Cause:AsessionwithSYSDBAprivilegeswasrequestedfromaSessionPoolwhichdoesnotsupportsessionswit...

IT技术学习 ·2025-02-17

ORA-13776: User “string” has not been granted the “SELECT” privilege on the “SQL tuning set” DBA views.

文档解释ORA-13776:User“string”hasnotbeengrantedthe“SELECT”privilegeonthe“SQLtuningset”DBAviews.Cause:TheuserattemptedtoreadaSQLt...

IT技术学习 ·2025-02-11

ORA-03139: This OCI call has been disabled by the DBA

文档解释ORA-03139:ThisOCIcallhasbeendisabledbytheDBACause:TheSEC_DISABLE_OLDER_ORACLE_RPCSinitializationparameterwasenabled.Action:ContacttheDatabaseAdministratorOR...

IT技术学习 ·2025-02-11

ORA-25162: Must specify both RDBA MIN and RDBA MAX options

文档解释ORA-25162:MustspecifybothRDBAMINandRDBAMAXoptionsCause:OnlyoneRDBAoptionwaspassedtoALTERSYSTEMDUMPREDO.Action:SpecifybothRDBAMINandRDBAMAX.ORA-25162错误是由在数据库...

IT技术学习 ·2025-02-11