[Home] [Help]
[Dependency Information]
TABLE: SYS.SEG$
Object Details
Object Name: | SEG$ |
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Storage Details
Tablespace: | SYSTEM |
PCT Free: | 0 |
PCT Used: | 0 |
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
FILE# |
NUMBER |
|
Yes |
|
BLOCK# |
NUMBER |
|
Yes |
|
TYPE# |
NUMBER |
|
Yes |
|
TS# |
NUMBER |
|
Yes |
|
BLOCKS |
NUMBER |
|
Yes |
|
EXTENTS |
NUMBER |
|
Yes |
|
INIEXTS |
NUMBER |
|
Yes |
|
MINEXTS |
NUMBER |
|
Yes |
|
MAXEXTS |
NUMBER |
|
Yes |
|
EXTSIZE |
NUMBER |
|
Yes |
|
EXTPCT |
NUMBER |
|
Yes |
|
USER# |
NUMBER |
|
Yes |
|
LISTS |
NUMBER |
|
|
|
GROUPS |
NUMBER |
|
|
|
BITMAPRANGES |
NUMBER |
|
Yes |
|
CACHEHINT |
NUMBER |
|
Yes |
|
SCANHINT |
NUMBER |
|
Yes |
|
HWMINCR |
NUMBER |
|
Yes |
|
SPARE1 |
NUMBER |
|
|
|
SPARE2 |
NUMBER |
|
|
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT FILE#
, BLOCK#
, TYPE#
, TS#
, BLOCKS
, EXTENTS
, INIEXTS
, MINEXTS
, MAXEXTS
, EXTSIZE
, EXTPCT
, USER#
, LISTS
, GROUPS
, BITMAPRANGES
, CACHEHINT
, SCANHINT
, HWMINCR
, SPARE1
, SPARE2
FROM SYS.SEG$;
Dependencies
[top of page]
SYS.SEG$ does not reference any database object
SYS.SEG$ is referenced by following:
-
SYS
-
AD_EXTENTS
-
ALL_INDEXES
-
ALL_IND_PARTITIONS
-
ALL_IND_SUBPARTITIONS
-
ALL_LOBS
-
ALL_LOB_PARTITIONS
-
ALL_LOB_SUBPARTITIONS
-
ALL_OBJECT_TABLES
-
ALL_TABLES
-
ALL_TAB_PARTITIONS
-
ALL_TAB_SUBPARTITIONS
-
DBA_INDEXES
-
DBA_IND_PARTITIONS
-
DBA_IND_SUBPARTITIONS
-
DBA_LOBS
-
DBA_LOB_PARTITIONS
-
DBA_LOB_SUBPARTITIONS
-
DBA_OBJECT_TABLES
-
DBA_ROLLBACK_SEGS
-
DBA_TABLES
-
DBA_TAB_PARTITIONS
-
DBA_TAB_SUBPARTITIONS
-
DBMSOBJG
- show dependent code
-
DBMS_COMPRESSION
- show dependent code
-
DBMS_FEATURE_DEFERRED_SEG_CRT
- show dependent code
-
DBMS_FEATURE_PARTITION_SYSTEM
- show dependent code
-
DBMS_FEATURE_PARTITION_USER
- show dependent code
-
DBMS_FEATURE_ZMAP
- show dependent code
-
DBMS_HEAT_MAP
- show dependent code
-
DBMS_LOGMNR_INTERNAL
- show dependent code
-
DBMS_PARALLEL_EXECUTE_EXTENTS
-
DBMS_PITR
- show dependent code
-
DBMS_PLUGTS
- show dependent code
-
DBMS_SPACE
- show dependent code
-
DBMS_STATS_INTERNAL
- show dependent code
-
EXPCOMPRESSEDPART
-
EXPCOMPRESSEDSUB
-
EXPCOMPRESSEDTAB
-
EXPMAPIOT
-
EXT_TO_OBJ_VIEW
-
EXU7RSG
-
EXU7STO
-
EXU7TNE
-
EXU8RSG
-
EXU9LOB
-
EXU9STO
-
INDEX_STATS
-
INT$DBA_CLUSTERS
-
KU$_ROLLBACK_VIEW
-
KU$_STORAGE_VIEW
-
LOGSTDBY_SUPPORT_TAB_10_1
-
LOGSTDBY_SUPPORT_TAB_10_2
-
LOGSTDBY_SUPPORT_TAB_11_1
-
LOGSTDBY_SUPPORT_TAB_11_2
-
LOGSTDBY_SUPPORT_TAB_11_2B
-
LOGSTDBY_UNSUPPORT_TAB_10_1
-
LOGSTDBY_UNSUPPORT_TAB_10_2
-
LOGSTDBY_UNSUPPORT_TAB_11_1
-
LOGSTDBY_UNSUPPORT_TAB_11_2
-
LOGSTDBY_UNSUPPORT_TAB_11_2B
-
PRVT_COMPRESS
- show dependent code
-
PRVT_ILM
- show dependent code
-
SYS_DBA_SEGS
-
SYS_UNCOMPRESSED_SEGS_BASE
-
SYS_USER_SEGS
-
TABQUOTAS
-
TBS_SPACE_USAGE
-
USER_INDEXES
-
USER_IND_PARTITIONS
-
USER_IND_SUBPARTITIONS
-
USER_LOBS
-
USER_LOB_PARTITIONS
-
USER_LOB_SUBPARTITIONS
-
USER_OBJECT_TABLES
-
USER_TABLES
-
USER_TAB_PARTITIONS
-
USER_TAB_SUBPARTITIONS
-
_DBA_STREAMS_UNSUPPORTED_10_1
-
_DBA_STREAMS_UNSUPPORTED_10_2
-
_DBA_STREAMS_UNSUPPORTED_11_1
-
_DBA_STREAMS_UNSUPPORTED_9_2
-
_utl$_gnp_ind
-
_utl$_gp_ind_parts
-
_utl$_lc_ind_subs
-
_utl$_lnc_ind_parts