[Home] [Help]
[Dependency Information]
TABLE: SYS.LOBFRAG$
Object Details
Object Name: | LOBFRAG$ |
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Storage Details
Tablespace: | SYSTEM |
PCT Free: | 10 |
PCT Used: | 40 |
Indexes
Index |
Type |
Uniqueness |
Tablespace |
Column |
I_LOBFRAG$_FRAGOBJ$
|
NORMAL
|
UNIQUE
|
SYSTEM
|
FRAGOBJ#
|
I_LOBFRAG_PARENTOBJFRAG$
|
NORMAL
|
UNIQUE
|
SYSTEM
|
PARENTOBJ#
FRAG#
|
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
FRAGOBJ# |
NUMBER |
|
Yes |
|
PARENTOBJ# |
NUMBER |
|
Yes |
|
TABFRAGOBJ# |
NUMBER |
|
Yes |
|
INDFRAGOBJ# |
NUMBER |
|
Yes |
|
FRAG# |
NUMBER |
|
Yes |
|
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.LOBFRAG$;
Dependencies
[top of page]
SYS.LOBFRAG$ does not reference any database object
SYS.LOBFRAG$ is referenced by following:
-
CTXSYS
-
DRIREPZ
- show dependent code
-
SYS
-
ALL_LOBS
-
ALL_LOB_PARTITIONS
-
ALL_LOB_SUBPARTITIONS
-
DBA_LOBS
-
DBA_LOB_PARTITIONS
-
DBA_LOB_SUBPARTITIONS
-
DBA_STREAMS_COLUMNS
-
DBMS_FEATURE_DEFERRED_SEG_CRT
- show dependent code
-
DBMS_FEATURE_SECUREFILES_SYS
- show dependent code
-
DBMS_FEATURE_SECUREFILES_USR
- show dependent code
-
DBMS_FEATURE_SFCOMPRESS_SYS
- show dependent code
-
DBMS_FEATURE_SFCOMPRESS_USR
- show dependent code
-
DBMS_FEATURE_SFDEDUP_SYS
- show dependent code
-
DBMS_FEATURE_SFDEDUP_USR
- show dependent code
-
DBMS_FEATURE_SFENCRYPT_SYS
- show dependent code
-
DBMS_FEATURE_SFENCRYPT_USR
- show dependent code
-
DBMS_LOGMNR_INTERNAL
- show dependent code
-
EXPTABSUBPARTLOBFRAG
-
EXU81LBSP
-
EXU9LBP
-
EXU9PLB
-
IMP_LOB_INFO
-
KU$_HTPART_BYTES_ALLOC_VIEW
-
KU$_HTSPART_BYTES_ALLOC_VIEW
-
KU$_IOTPART_BYTES_ALLOC_VIEW
-
KU$_LOBFRAG_VIEW
-
KU$_PARTLOB_VIEW
-
KU$_PIOTLOBFRAG_VIEW
-
KU$_SUBLOBFRAG_VIEW
-
KU$_TEMP_SUBPARTLOBFRG_VIEW
-
KU$_TTS_PARTLOBVIEW
-
KU$_TTS_SUBPARTLOBVIEW
-
KU$_TTS_TABVIEW
-
LOBFRAGV$
-
LOGSTDBY_SUPPORT_11LOB
-
PRVT_ILM
- show dependent code
-
STRADDLING_RS_OBJECTS
-
STRADDLING_TS_OBJECTS
-
SYS_OBJECTS
-
USER_LOBS
-
USER_LOB_PARTITIONS
-
USER_LOB_SUBPARTITIONS
-
_DBA_STREAMS_UNSUPPORTED_11_1
-
_DBA_STREAMS_UNSUPPORTED_11_2
-
_DBA_STREAMS_UNSUPPORTED_12_1