DBA Data[Home] [Help] [Dependency Information]


VIEW: SYS.DBA_WARNING_SETTINGS

Object Details
Object Name: DBA_WARNING_SETTINGS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

warning settings for all objects

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (128) Yes Username of the owner of the object
OBJECT_NAME VARCHAR2 (128) Yes Name of the object
OBJECT_ID NUMBER
Yes Object number of the object
OBJECT_TYPE VARCHAR2 (12)
Type of the object
WARNING VARCHAR2 (40)
Warning number or category
SETTING VARCHAR2 (7)
Value of the warning setting
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT OWNER
,      OBJECT_NAME
,      OBJECT_ID
,      OBJECT_TYPE
,      WARNING
,      SETTING
FROM SYS.DBA_WARNING_SETTINGS;

Dependencies

[top of page]

SYS.DBA_WARNING_SETTINGS references the following:

SchemaSYS
PL/SQL PackageDBMS_WARNING_INTERNAL - show dependent code
TYPESYS_PLSQL_5A64B710_32_1
TableUSER$
View_CURRENT_EDITION_OBJ
SYS.DBA_WARNING_SETTINGS is referenced by following:

SchemaPUBLIC
SynonymDBA_WARNING_SETTINGS