eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: SYS.KU$_M_ZONEMAP_VIEW

Object Details

Object Name:	KU$_M_ZONEMAP_VIEW
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
VERS_MAJOR	CHAR	(1)
VERS_MINOR	CHAR	(1)
SOWNER	VARCHAR2	(128)
VNAME	VARCHAR2	(128)
TNAME	VARCHAR2	(128)
MOWNER	VARCHAR2	(128)
MASTER	VARCHAR2	(128)
MLINK	VARCHAR2	(128)
BASE_OBJ_NUM	NUMBER
SNAPSHOT	VARCHAR2	(19)
SNAPID	NUMBER
AUTO_FAST	VARCHAR2	(8)
AUTO_FUN	VARCHAR2	(200)
AUTO_DATE	VARCHAR2	(19)
USLOG	VARCHAR2	(128)
STATUS	NUMBER
MASTER_VERSION	NUMBER
TABLES	NUMBER
FLAG	NUMBER
FLAG2	NUMBER
FLAG3	NUMBER
LOBMASKVEC	RAW	(255)
MAS_ROLL_SEG	VARCHAR2	(128)
RSCN	NUMBER
INSTSITE	NUMBER
FLAVOR_ID	NUMBER
OBJFLAG	NUMBER
SNA_TYPE_OWNER	VARCHAR2	(128)
SNA_TYPE_NAME	VARCHAR2	(128)
MAS_TYPE_OWNER	VARCHAR2	(128)
MAS_TYPE_NAME	VARCHAR2	(128)
PARENT_SOWNER	VARCHAR2	(128)
PARENT_VNAME	VARCHAR2	(128)
QUERY_LEN	NUMBER
QUERY_TXT	CLOB	(4000)
PARSED_QUERY_TXT	XMLTYPE	(64)
QUERY_VCNT	KU$_VCNT	(0)
REL_QUERY	CLOB	(4000)
LOC_ROLL_SEG	VARCHAR2	(128)
GLOBAL_DB_NAME	VARCHAR2	(4000)
SYN_COUNT	NUMBER
SRT_LIST	KU$_M_VIEW_SRT_LIST_T	(64)
MFLAGS	NUMBER
XPFLAGS	NUMBER
ZMAPSCALE	NUMBER
EVALEDITION_NUM	NUMBER
UNUSABLEBEF_NUM	NUMBER
UNUSABLEBEG_NUM	NUMBER

Query Text

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


SELECT VERS_MAJOR
,      VERS_MINOR
,      SOWNER
,      VNAME
,      TNAME
,      MOWNER
,      MASTER
,      MLINK
,      BASE_OBJ_NUM
,      SNAPSHOT
,      SNAPID
,      AUTO_FAST
,      AUTO_FUN
,      AUTO_DATE
,      USLOG
,      STATUS
,      MASTER_VERSION
,      TABLES
,      FLAG
,      FLAG2
,      FLAG3
,      LOBMASKVEC
,      MAS_ROLL_SEG
,      RSCN
,      INSTSITE
,      FLAVOR_ID
,      OBJFLAG
,      SNA_TYPE_OWNER
,      SNA_TYPE_NAME
,      MAS_TYPE_OWNER
,      MAS_TYPE_NAME
,      PARENT_SOWNER
,      PARENT_VNAME
,      QUERY_LEN
,      QUERY_TXT
,      PARSED_QUERY_TXT
,      QUERY_VCNT
,      REL_QUERY
,      LOC_ROLL_SEG
,      GLOBAL_DB_NAME
,      SYN_COUNT
,      SRT_LIST
,      MFLAGS
,      XPFLAGS
,      ZMAPSCALE
,      EVALEDITION_NUM
,      UNUSABLEBEF_NUM
,      UNUSABLEBEG_NUM
FROM SYS.KU$_M_ZONEMAP_VIEW;

Dependencies

[top of page]

SYS.KU$_M_ZONEMAP_VIEW references the following:

SYS: DBMS_METADATA - show dependent code; DBMS_METADATA_UTIL - show dependent code; KU$_M_VIEW_SCM_LIST_T; KU$_M_VIEW_SRT_LIST_T; KU$_M_VIEW_T; KU$_M_VIEW_VIEW_BASE; KU$_VCNT; STANDARD - show dependent code; XMLTYPE

SYS.KU$_M_ZONEMAP_VIEW is referenced by following:

SYS: KU$_M_ZONEMAP_FH_VIEW; KU$_M_ZONEMAP_H_VIEW; KU$_M_ZONEMAP_IOT_VIEW; KU$_M_ZONEMAP_PFH_VIEW; KU$_M_ZONEMAP_PH_VIEW; KU$_M_ZONEMAP_PIOT_VIEW