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.EXU81LBSP

Object Details

Object Name:	EXU81LBSP
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
POBJID	NUMBER		Yes
TOBJID	NUMBER		Yes
OWNERID	NUMBER		Yes
CNAME	VARCHAR2	(4000)
LOBSPNAME	VARCHAR2	(128)
TSNAME	VARCHAR2	(30)	Yes
SGFLAGS	NUMBER
TSNO	NUMBER		Yes
FILENO	NUMBER		Yes
BLOCKNO	NUMBER		Yes
DOBJID	NUMBER
INAME	VARCHAR2	(128)	Yes
ISGFLAG	NUMBER
ITSNAME	VARCHAR2	(30)	Yes
ITSNO	NUMBER		Yes
IFILE	NUMBER		Yes
IBLOCK	NUMBER		Yes
IDOBJID	NUMBER
IINITRANS	NUMBER		Yes
IMAXTRANS	NUMBER		Yes
COLTYPE	NUMBER
COLTYPFLG	NUMBER
BLOCKSIZE	NUMBER		Yes
FLAGS	NUMBER		Yes

Query Text

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


SELECT POBJID
,      TOBJID
,      OWNERID
,      CNAME
,      LOBSPNAME
,      TSNAME
,      SGFLAGS
,      TSNO
,      FILENO
,      BLOCKNO
,      DOBJID
,      INAME
,      ISGFLAG
,      ITSNAME
,      ITSNO
,      IFILE
,      IBLOCK
,      IDOBJID
,      IINITRANS
,      IMAXTRANS
,      COLTYPE
,      COLTYPFLG
,      BLOCKSIZE
,      FLAGS
FROM SYS.EXU81LBSP;

Dependencies

[top of page]

SYS.EXU81LBSP references the following:

SYS: ATTRCOL$; COL$; COLTYPE$; INDSUBPART$; LOB$; LOBCOMPPART$; LOBFRAG$; OBJ$; PARTOBJ$; TS$

SYS.EXU81LBSP is referenced by following:

SYS: EXU81LBSPU