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]

TABLE: SYS.STREAMS$_DEF_PROC

Object Details

Object Name:	STREAMS$_DEF_PROC
Object Type:	TABLE
Owner:	SYS
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Indexes

Index	Type	Uniqueness	Tablespace
SYS_IL0000226324C00013$$	LOB	UNIQUE	SYSTEM
SYS_IL0000226324C00014$$	LOB	UNIQUE	SYSTEM
SYS_IL0000226324C00015$$	LOB	UNIQUE	SYSTEM

Columns

Name	Datatype	Length
BASE_OBJ_NUM	NUMBER
FLAGS	NUMBER
OWNER	VARCHAR2	(128)
PACKAGE_NAME	VARCHAR2	(128)
PROCEDURE_NAME	VARCHAR2	(128)
PARAM_NAME	VARCHAR2	(128)
PARAM_TYPE	NUMBER
RAW_VALUE	RAW	(2000)
NUMBER_VALUE	NUMBER
DATE_VALUE	DATE
VARCHAR2_VALUE	VARCHAR2	(4000)
NVARCHAR2_VALUE	NVARCHAR2	(2000)
CLOB_VALUE	CLOB	(4000)
BLOB_VALUE	BLOB	(4000)
NCLOB_VALUE	NCLOB	(4000)

Query Text

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


SELECT BASE_OBJ_NUM
,      FLAGS
,      OWNER
,      PACKAGE_NAME
,      PROCEDURE_NAME
,      PARAM_NAME
,      PARAM_TYPE
,      RAW_VALUE
,      NUMBER_VALUE
,      DATE_VALUE
,      VARCHAR2_VALUE
,      NVARCHAR2_VALUE
,      CLOB_VALUE
,      BLOB_VALUE
,      NCLOB_VALUE
FROM SYS.STREAMS$_DEF_PROC;

Dependencies

[top of page]

SYS.STREAMS$_DEF_PROC does not reference any database object

SYS.STREAMS$_DEF_PROC is not referenced by any database object