[Home] [Help]
[Dependency Information]
TABLE: SYS.TAB$
Object Details
Object Name: | TAB$ |
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Storage Details
Tablespace: | SYSTEM |
PCT Free: | 0 |
PCT Used: | 0 |
Indexes
Index |
Type |
Uniqueness |
Tablespace |
Column |
I_TAB1
|
NORMAL
|
NONUNIQUE
|
SYSTEM
|
BOBJ#
|
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
OBJ# |
NUMBER |
|
Yes |
|
DATAOBJ# |
NUMBER |
|
|
|
TS# |
NUMBER |
|
Yes |
|
FILE# |
NUMBER |
|
Yes |
|
BLOCK# |
NUMBER |
|
Yes |
|
BOBJ# |
NUMBER |
|
|
|
TAB# |
NUMBER |
|
|
|
COLS |
NUMBER |
|
Yes |
|
CLUCOLS |
NUMBER |
|
|
|
PCTFREE$ |
NUMBER |
|
Yes |
|
PCTUSED$ |
NUMBER |
|
Yes |
|
INITRANS |
NUMBER |
|
Yes |
|
MAXTRANS |
NUMBER |
|
Yes |
|
FLAGS |
NUMBER |
|
Yes |
|
AUDIT$ |
VARCHAR2 |
(38) |
Yes |
|
ROWCNT |
NUMBER |
|
|
|
BLKCNT |
NUMBER |
|
|
|
EMPCNT |
NUMBER |
|
|
|
AVGSPC |
NUMBER |
|
|
|
CHNCNT |
NUMBER |
|
|
|
AVGRLN |
NUMBER |
|
|
|
AVGSPC_FLB |
NUMBER |
|
|
|
FLBCNT |
NUMBER |
|
|
|
ANALYZETIME |
DATE |
|
|
|
SAMPLESIZE |
NUMBER |
|
|
|
DEGREE |
NUMBER |
|
|
|
INSTANCES |
NUMBER |
|
|
|
INTCOLS |
NUMBER |
|
Yes |
|
KERNELCOLS |
NUMBER |
|
Yes |
|
PROPERTY |
NUMBER |
|
Yes |
|
TRIGFLAG |
NUMBER |
|
|
|
SPARE1 |
NUMBER |
|
|
|
SPARE2 |
NUMBER |
|
|
|
SPARE3 |
NUMBER |
|
|
|
SPARE4 |
VARCHAR2 |
(1000) |
|
|
SPARE5 |
VARCHAR2 |
(1000) |
|
|
SPARE6 |
DATE |
|
|
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT OBJ#
, DATAOBJ#
, TS#
, FILE#
, BLOCK#
, BOBJ#
, TAB#
, COLS
, CLUCOLS
, PCTFREE$
, PCTUSED$
, INITRANS
, MAXTRANS
, FLAGS
, AUDIT$
, ROWCNT
, BLKCNT
, EMPCNT
, AVGSPC
, CHNCNT
, AVGRLN
, AVGSPC_FLB
, FLBCNT
, ANALYZETIME
, SAMPLESIZE
, DEGREE
, INSTANCES
, INTCOLS
, KERNELCOLS
, PROPERTY
, TRIGFLAG
, SPARE1
, SPARE2
, SPARE3
, SPARE4
, SPARE5
, SPARE6
FROM SYS.TAB$;
Dependencies
[top of page]
SYS.TAB$ does not reference any database object
SYS.TAB$ is referenced by following:
-
APPS
-
AD_PARALLEL_UPDATES_PKG
- show dependent code
-
CTXSYS
-
DRIREPZ
- show dependent code
-
DRI_MOVE_CTXSYS
- show dependent code
-
SYS
-
AD_EXTENTS
-
ALL_CATALOG
-
ALL_DEF_AUDIT_OPTS
-
ALL_IND_PARTITIONS
-
ALL_IND_STATISTICS
-
ALL_IND_SUBPARTITIONS
-
ALL_INTERNAL_TRIGGERS
-
ALL_LOBS
-
ALL_LOB_PARTITIONS
-
ALL_LOB_SUBPARTITIONS
-
ALL_MVIEW_COMMENTS
-
ALL_NESTED_TABLE_COLS
-
ALL_OBJECT_TABLES
-
ALL_PARTIAL_DROP_TABS
-
ALL_PART_TABLES
-
ALL_STAT_EXTENSIONS
-
ALL_SYNC_CAPTURE_TABLES
-
ALL_TABLES
-
ALL_TAB_COLS_V$
-
ALL_TAB_HISTOGRAMS
-
ALL_TAB_MODIFICATIONS
-
ALL_TAB_PARTITIONS
-
ALL_TAB_STATISTICS
-
ALL_TAB_SUBPARTITIONS
-
ALL_TSTZ_TABLES
-
ALL_TSTZ_TAB_COLS
-
ALL_XML_TABLES
-
ALL_XML_TAB_COLS
-
DBA_ANALYZE_OBJECTS
-
DBA_CATALOG
-
DBA_CLU_COLUMNS
-
DBA_IND_PARTITIONS
-
DBA_IND_STATISTICS
-
DBA_IND_SUBPARTITIONS
-
DBA_INTERNAL_TRIGGERS
-
DBA_LOBS
-
DBA_LOB_PARTITIONS
-
DBA_LOB_SUBPARTITIONS
-
DBA_LOGSTDBY_EDS_SUPPORTED
-
DBA_LOGSTDBY_NOT_UNIQUE
-
DBA_MVIEWS
-
DBA_MVIEW_COMMENTS
-
DBA_NESTED_TABLE_COLS
-
DBA_OBJECT_TABLES
-
DBA_OBJ_AUDIT_OPTS
-
DBA_PARTIAL_DROP_TABS
-
DBA_PART_TABLES
-
DBA_STAT_EXTENSIONS
-
DBA_STREAMS_COLUMNS
-
DBA_SYNC_CAPTURE_TABLES
-
DBA_TABLES
-
DBA_TAB_COLS_V$
-
DBA_TAB_HISTOGRAMS
-
DBA_TAB_MODIFICATIONS
-
DBA_TAB_PARTITIONS
-
DBA_TAB_STATISTICS
-
DBA_TAB_SUBPARTITIONS
-
DBA_TSTZ_TABLES
-
DBA_XML_TABLES
-
DBA_XML_TAB_COLS
-
DBMSOBJG
- show dependent code
-
DBMSOBJG2
- show dependent code
-
DBMS_AQ_SYS_IMP_INTERNAL
- show dependent code
-
DBMS_CAPTURE_ADM_INTERNAL
- show dependent code
-
DBMS_EXTENDED_TTS_CHECKS
- show dependent code
-
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_FEATURE_ZMAP
- show dependent code
-
DBMS_ILM_ADMIN
- show dependent code
-
DBMS_INTERNAL_LOGSTDBY
- show dependent code
-
DBMS_LOGMNR_D
- show dependent code
-
DBMS_LOGMNR_INTERNAL
- show dependent code
-
DBMS_METADATA_UTIL
- show dependent code
-
DBMS_PARALLEL_EXECUTE_EXTENTS
-
DBMS_PITR
- show dependent code
-
DBMS_PLUGTS
- show dependent code
-
DBMS_PRVTAQIS
- show dependent code
-
DBMS_REDEFINITION_INTERNAL
- show dependent code
-
DBMS_REPCAT_COMMON_UTL
- show dependent code
-
DBMS_REPCAT_MIG_INTERNAL
- show dependent code
-
DBMS_REPCAT_UTL2
- show dependent code
-
DBMS_REPCAT_UTL3
- show dependent code
-
DBMS_SNAP_INTERNAL
- show dependent code
-
DBMS_STATS
- show dependent code
-
DBMS_STATS_INTERNAL
- show dependent code
-
DBMS_STATS_INTERNAL
- show dependent code
-
DMP_SEC
- show dependent code
-
EXPCOMPRESSEDTAB
-
EXPGETMAPOBJ
-
EXPMAPIOT
-
EXT_TO_OBJ_VIEW
-
EXU10DOSO
-
EXU10TABS
-
EXU10USCI
-
EXU11IND_BASE
-
EXU11SNAP
-
EXU7ANAL
-
EXU7CCO
-
EXU7TAB
-
EXU816TCTX
-
EXU816TGR
-
EXU81PROCOBJINSTANCE
-
EXU81TTS
-
EXU81USCI
-
EXU8ANAL
-
EXU8CCO
-
EXU8IOV
-
EXU8NTB
-
EXU8PST
-
EXU8REF
-
EXU8RIF
-
EXU8TNTIC
-
EXU8USCU
-
EXU92TGR
-
EXU9ACTIONOBJ
-
EXU9LTTS
-
EXU9TABC
-
EXU9TABI
-
IMP_LOB_INFO
-
INT$DBA_TAB_COMMENTS
-
KU$_10_1_PTAB_STATS_VIEW
-
KU$_10_1_TAB_ONLY_STATS_VIEW
-
KU$_10_1_TAB_STATS_VIEW
-
KU$_10_2_FHTABLE_VIEW
-
KU$_10_2_STRMTABLE_VIEW
-
KU$_10_2_TAB_STATS_VIEW
-
KU$_11_2_TAB_STATS_VIEW
-
KU$_2NDTAB_INFO_VIEW
-
KU$_2ND_TABLE_OBJNUM_VIEW
-
KU$_ACPTABLE_VIEW
-
KU$_ALL_INDEX_VIEW
-
KU$_ALL_TSLTZ_TAB_COLS
-
KU$_AUDIT_DEFAULT_VIEW
-
KU$_AUDIT_OBJ_BASE_VIEW
-
KU$_CHILD_NESTED_TAB_VIEW
-
KU$_COMMENT_VIEW
-
KU$_CONSTRAINT1_VIEW
-
KU$_DEPTABLE_OBJNUM_VIEW
-
KU$_EQNTABLE_BYTES_ALLOC_VIEW
-
KU$_EQNTABLE_DATA_VIEW
-
KU$_FHTABLE_VIEW
-
KU$_HISTGRM_VIEW
-
KU$_HNTP_VIEW
-
KU$_HNT_VIEW
-
KU$_HTABLE_BYTES_ALLOC_VIEW
-
KU$_HTABLE_DATA_VIEW
-
KU$_HTABLE_VIEW
-
KU$_HTPART_BYTES_ALLOC_VIEW
-
KU$_HTPART_DATA_VIEW
-
KU$_HTSPART_BYTES_ALLOC_VIEW
-
KU$_HTSPART_DATA_VIEW
-
KU$_IDENTITY_COLOBJ_VIEW
-
KU$_IONT_VIEW
-
KU$_IOTABLE_BYTES_ALLOC_VIEW
-
KU$_IOTABLE_DATA_VIEW
-
KU$_IOTABLE_VIEW
-
KU$_IOTPART_BYTES_ALLOC_VIEW
-
KU$_IOTPART_DATA_VIEW
-
KU$_IOT_PARTOBJ_VIEW
-
KU$_MAP_TABLE_VIEW
-
KU$_MONITOR_VIEW
-
KU$_MVLPROP_VIEW
-
KU$_MVPROP_VIEW
-
KU$_MZPROP_VIEW
-
KU$_NIOTABLE_DATA_VIEW
-
KU$_NTABLE_BYTES_ALLOC_VIEW
-
KU$_NTABLE_DATA_VIEW
-
KU$_NTABLE_OBJNUM_VIEW
-
KU$_NTPART_PARENT_VIEW
-
KU$_NTPART_VIEW
-
KU$_NT_PARENT_VIEW
-
KU$_OBJGRANT_VIEW
-
KU$_OV_TABLE_VIEW
-
KU$_PARTITION_EST_VIEW
-
KU$_PFHTABLE_VIEW
-
KU$_PHTABLE_VIEW
-
KU$_PIOTABLE_VIEW
-
KU$_POST_DATA_TABLE_VIEW
-
KU$_POST_TABLE_VIEW
-
KU$_PRE_TABLE_VIEW
-
KU$_PTABLE_TS_VIEW
-
KU$_PTAB_STATS_VIEW
-
KU$_QTAB_STORAGE_VIEW
-
KU$_REFPAR_LEVEL
-
KU$_STRMTABLE_VIEW
-
KU$_SUBPARTITION_EST_VIEW
-
KU$_TABCLUSTER_COL_VIEW
-
KU$_TABCLUSTER_VIEW
-
KU$_TABLE_EST_VIEW
-
KU$_TABLE_OBJNUM_VIEW
-
KU$_TABPROP_VIEW
-
KU$_TAB_ONLY_STATS_VIEW
-
KU$_TAB_STATS_VIEW
-
KU$_TRIGGER_VIEW
-
KU$_TTS_MVL_VIEW
-
KU$_TTS_MV_VIEW
-
KU$_TTS_TABVIEW
-
KU$_TTS_VIEW
-
KU$_UNLOAD_METHOD_VIEW
-
KU$_XDB_NTABLE_OBJNUM_VIEW
-
LOADER_PART_INFO
-
LOADER_TAB_INFO
-
LOGMNR_DDL_TRIGGER_PROC
- show dependent code
-
LOGMNR_DICT_CACHE
- show dependent code
-
LOGMNR_GTCS_CAT_SUPPORT
-
LOGMNR_KRVRDLUID3
- show dependent code
-
LOGMNR_TAB_COLS_CAT_SUPPORT
-
LOGSTDBY_RU_UNSUPPORT_TAB_12_1
-
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_SUPPORT_TAB_12_1
-
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
-
LOGSTDBY_UNSUPPORT_TAB_12_1
-
PRVT_COMPRESS
- show dependent code
-
PRVT_ILM
- show dependent code
-
REPCAT_REPOBJECT_BASE
-
STRADDLING_RS_OBJECTS
-
STRADDLING_TS_OBJECTS
-
SYSCATALOG_
-
SYSSEGOBJ
-
SYS_OBJECTS
-
TAB
-
TTS_TAB_VIEW
-
USER_CATALOG
-
USER_CLU_COLUMNS
-
USER_IND_PARTITIONS
-
USER_IND_STATISTICS
-
USER_IND_SUBPARTITIONS
-
USER_INTERNAL_TRIGGERS
-
USER_LOBS
-
USER_LOB_PARTITIONS
-
USER_LOB_SUBPARTITIONS
-
USER_MVIEW_COMMENTS
-
USER_NESTED_TABLE_COLS
-
USER_OBJECT_TABLES
-
USER_OBJ_AUDIT_OPTS
-
USER_PARTIAL_DROP_TABS
-
USER_PART_TABLES
-
USER_STAT_EXTENSIONS
-
USER_TABLES
-
USER_TAB_COLS_V$
-
USER_TAB_HISTOGRAMS
-
USER_TAB_MODIFICATIONS
-
USER_TAB_PARTITIONS
-
USER_TAB_STATISTICS
-
USER_TAB_SUBPARTITIONS
-
USER_TSTZ_TABLES
-
USER_XML_TABLES
-
USER_XML_TAB_COLS
-
_DBA_REPL_NESTED_TABLE_NAMES
-
_DBA_STREAMS_UNSUPPORTED_10_1
-
_DBA_STREAMS_UNSUPPORTED_10_2
-
_DBA_STREAMS_UNSUPPORTED_11_1
-
_DBA_STREAMS_UNSUPPORTED_11_2
-
_DBA_STREAMS_UNSUPPORTED_12_1
-
_DBA_STREAMS_UNSUPPORTED_9_2
-
_DBA_XSTREAM_OUT_ALL_TABLES
-
_user_stat
-
_utl$_gnp_ind
-
_utl$_gp_ind_parts
-
_utl$_lc_ind_subs
-
_utl$_lnc_ind_parts