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

VIEW: SYS.LOBFRAGV$

Object Details
Object Name: LOBFRAGV$
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
FRAGOBJ# NUMBER
Yes
PARENTOBJ# NUMBER
Yes
TABFRAGOBJ# NUMBER
Yes
INDFRAGOBJ# NUMBER
Yes
FRAG# NUMBER

FRAGTYPE$ VARCHAR2 (1)
TS# NUMBER
Yes
FILE# NUMBER
Yes
BLOCK# NUMBER
Yes
CHUNK NUMBER
Yes
PCTVERSION$ NUMBER
Yes
FRAGFLAGS NUMBER
Yes
FRAGPRO NUMBER
Yes
SPARE1 NUMBER

SPARE2 NUMBER

SPARE3 NUMBER

Query Text

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


SELECT FRAGOBJ#
,      PARENTOBJ#
,      TABFRAGOBJ#
,      INDFRAGOBJ#
,      FRAG#
,      FRAGTYPE$
,      TS#
,      FILE#
,      BLOCK#
,      CHUNK
,      PCTVERSION$
,      FRAGFLAGS
,      FRAGPRO
,      SPARE1
,      SPARE2
,      SPARE3
FROM SYS.LOBFRAGV$;

Dependencies

[top of page]

SYS.LOBFRAGV$ references the following:

SchemaSYS
TableLOBFRAG$

SYS.LOBFRAGV$ is not referenced by any database object