ORACLE_MAINTAINED是Oracle 12c中一系列视图的新增信息字段，该字段代表对象或用户是Oracle提供的脚本生成的，即Oracle-Supplied objects。
ORACLE_MAINTAINED |
VARCHAR2(1) |
Denotes whether the object was created, and is maintained, by Oracle-supplied scripts (such as catalog.sql or catproc.sql). An object for which this column has the value Y must not be changed in any way except by running an Oracle-supplied script. |
我们来看看那些视图有该字段
oracle@localhost:/u01/app/oracle/product/12.1.0/dbhome_1/rdbms/admin$ grep -i "ORACLE_MAINTAINED" *|grep comment cdcore.sql:comment on column USER_OBJECTS.ORACLE_MAINTAINED is cdcore.sql:comment on column ALL_OBJECTS.ORACLE_MAINTAINED is cdcore.sql:comment on column DBA_OBJECTS.ORACLE_MAINTAINED is cdcore.sql:comment on column USER_OBJECTS_AE.ORACLE_MAINTAINED is cdcore.sql:comment on column ALL_OBJECTS_AE.ORACLE_MAINTAINED is cdcore.sql:comment on column DBA_OBJECTS_AE.ORACLE_MAINTAINED is cdenv.sql:comment on column USER_USERS.ORACLE_MAINTAINED is cdenv.sql:comment on column ALL_USERS.ORACLE_MAINTAINED is cdenv.sql:comment on column DBA_USERS.ORACLE_MAINTAINED is cdsec.sql:comment on column DBA_ROLES.ORACLE_MAINTAINED is
DBA_USERS、DBA_OBJECTS、DBA_OBJECTS_AE以及与之相关的ALL_、USER_视图均有ORACLE_MAINTAINED字段。
以下为ORACLE MAINTAINED用户名
1* select username from dba_users where ORACLE_MAINTAINED='Y' SQL> / USERNAME -------------------------------------------------------------------------------------------------------------------------------- AUDSYS GSMUSER SPATIAL_WFS_ADMIN_USR SPATIAL_CSW_ADMIN_USR APEX_PUBLIC_USER SYSDG DIP SYSBACKUP MDDATA GSMCATUSER SYSKM XS$NULL OJVMSYS ORACLE_OCM OLAPSYS SI_INFORMTN_SCHEMA DVSYS ORDPLUGINS XDB ANONYMOUS CTXSYS ORDDATA GSMADMIN_INTERNAL APPQOSSYS APEX_040200 WMSYS DBSNMP ORDSYS MDSYS DVF FLOWS_FILES SYS SYSTEM OUTLN LBACSYS
Leave a Reply