oracle中的orddata,【Oracle Database 12c新特性】ORACLE_MAINTAINED

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