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.V_$DIAG_DIR_EXT

Object Details

Object Name:	V_$DIAG_DIR_EXT
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
ADDR	RAW	(8)
INDX	NUMBER
INST_ID	NUMBER
CON_ID	NUMBER
ADR_PATH_IDX	VARCHAR2	(445)
ADR_HOME	VARCHAR2	(445)
PHYSICAL_PATH	VARCHAR2	(447)
LOGICAL_PATH	VARCHAR2	(447)
PHYSICAL_FILENAME	VARCHAR2	(71)
LOGICAL_FILENAME	VARCHAR2	(71)
TYPE	NUMBER
LEVEL	NUMBER
CREATION_TIMESTAMP	TIMESTAMP(9) WITH TIME ZONE	(20)
MODIFICATION_TIMESTAMP	TIMESTAMP(9) WITH TIME ZONE	(20)
ROOT_DIR	VARCHAR2	(447)

Query Text

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


SELECT ADDR
,      INDX
,      INST_ID
,      CON_ID
,      ADR_PATH_IDX
,      ADR_HOME
,      PHYSICAL_PATH
,      LOGICAL_PATH
,      PHYSICAL_FILENAME
,      LOGICAL_FILENAME
,      TYPE
,      LEVEL
,      CREATION_TIMESTAMP
,      MODIFICATION_TIMESTAMP
,      ROOT_DIR
FROM SYS.V_$DIAG_DIR_EXT;

Dependencies

[top of page]

SYS.V_$DIAG_DIR_EXT references the following:

SYS.V_$DIAG_DIR_EXT is referenced by following:

PUBLIC: V$DIAG_DIR_EXT