[Home] [Help]
[Dependency Information]
TABLE: SYS.TS$
Object Details
Object Name: | TS$ |
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_TS1
|
NORMAL
|
UNIQUE
|
SYSTEM
|
NAME
|
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
TS# |
NUMBER |
|
Yes |
|
NAME |
VARCHAR2 |
(30) |
Yes |
|
OWNER# |
NUMBER |
|
Yes |
|
ONLINE$ |
NUMBER |
|
Yes |
|
CONTENTS$ |
NUMBER |
|
Yes |
|
UNDOFILE# |
NUMBER |
|
|
|
UNDOBLOCK# |
NUMBER |
|
|
|
BLOCKSIZE |
NUMBER |
|
Yes |
|
INC# |
NUMBER |
|
Yes |
|
SCNWRP |
NUMBER |
|
|
|
SCNBAS |
NUMBER |
|
|
|
DFLMINEXT |
NUMBER |
|
Yes |
|
DFLMAXEXT |
NUMBER |
|
Yes |
|
DFLINIT |
NUMBER |
|
Yes |
|
DFLINCR |
NUMBER |
|
Yes |
|
DFLMINLEN |
NUMBER |
|
Yes |
|
DFLEXTPCT |
NUMBER |
|
Yes |
|
DFLOGGING |
NUMBER |
|
Yes |
|
AFFSTRENGTH |
NUMBER |
|
Yes |
|
BITMAPPED |
NUMBER |
|
Yes |
|
PLUGGED |
NUMBER |
|
Yes |
|
DIRECTALLOWED |
NUMBER |
|
Yes |
|
FLAGS |
NUMBER |
|
Yes |
|
PITRSCNWRP |
NUMBER |
|
|
|
PITRSCNBAS |
NUMBER |
|
|
|
OWNERINSTANCE |
VARCHAR2 |
(30) |
|
|
BACKUPOWNER |
VARCHAR2 |
(30) |
|
|
GROUPNAME |
VARCHAR2 |
(30) |
|
|
SPARE1 |
NUMBER |
|
|
|
SPARE2 |
NUMBER |
|
|
|
SPARE3 |
VARCHAR2 |
(1000) |
|
|
SPARE4 |
DATE |
|
|
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT TS#
, NAME
, OWNER#
, ONLINE$
, CONTENTS$
, UNDOFILE#
, UNDOBLOCK#
, BLOCKSIZE
, INC#
, SCNWRP
, SCNBAS
, DFLMINEXT
, DFLMAXEXT
, DFLINIT
, DFLINCR
, DFLMINLEN
, DFLEXTPCT
, DFLOGGING
, AFFSTRENGTH
, BITMAPPED
, PLUGGED
, DIRECTALLOWED
, FLAGS
, PITRSCNWRP
, PITRSCNBAS
, OWNERINSTANCE
, BACKUPOWNER
, GROUPNAME
, SPARE1
, SPARE2
, SPARE3
, SPARE4
FROM SYS.TS$;
Dependencies
[top of page]
SYS.TS$ does not reference any database object
SYS.TS$ is referenced by following:
-
CTXSYS
-
DRIREPZ
- show dependent code
-
SYS
-
AD_EXTENTS
-
ALL_INDEXES
-
ALL_IND_PARTITIONS
-
ALL_IND_SUBPARTITIONS
-
ALL_LOBS
-
ALL_LOB_PARTITIONS
-
ALL_LOB_SUBPARTITIONS
-
ALL_LOB_TEMPLATES
-
ALL_OBJECT_TABLES
-
ALL_PART_INDEXES
-
ALL_PART_LOBS
-
ALL_PART_TABLES
-
ALL_SUBPARTITION_TEMPLATES
-
ALL_TABLES
-
ALL_TAB_PARTITIONS
-
ALL_TAB_SUBPARTITIONS
-
ALL_USERS
-
DBA_DATA_FILES
-
DBA_FLASHBACK_ARCHIVE_TS
-
DBA_FREE_SPACE
-
DBA_FREE_SPACE_COALESCED
-
DBA_FREE_SPACE_COALESCED_TMP1
-
DBA_FREE_SPACE_COALESCED_TMP2
-
DBA_FREE_SPACE_COALESCED_TMP3
-
DBA_ILMOBJECTS
-
DBA_ILMPOLICIES
-
DBA_INDEXES
-
DBA_IND_PARTITIONS
-
DBA_IND_SUBPARTITIONS
-
DBA_LOBS
-
DBA_LOB_PARTITIONS
-
DBA_LOB_SUBPARTITIONS
-
DBA_LOB_TEMPLATES
-
DBA_OBJECT_TABLES
-
DBA_PART_INDEXES
-
DBA_PART_LOBS
-
DBA_PART_TABLES
-
DBA_RECYCLEBIN
-
DBA_ROLLBACK_SEGS
-
DBA_SECUREFILE_LOG_PARTITIONS
-
DBA_SECUREFILE_LOG_TABLES
-
DBA_SUBPARTITION_TEMPLATES
-
DBA_TABLES
-
DBA_TABLESPACES
-
DBA_TABLESPACE_GROUPS
-
DBA_TABLESPACE_USAGE_METRICS
-
DBA_TAB_PARTITIONS
-
DBA_TAB_SUBPARTITIONS
-
DBA_TEMP_FILES
-
DBA_TEMP_FREE_SPACE
-
DBA_TS_QUOTAS
-
DBA_UNDO_EXTENTS
-
DBA_USERS
-
DBMSOBJG
- show dependent code
-
DBMSOBJG2
- show dependent code
-
DBMS_EXTENDED_TTS_CHECKS
- show dependent code
-
DBMS_HEAT_MAP
- 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_PARALLEL_EXECUTE_EXTENTS
-
DBMS_PITR
- show dependent code
-
DBMS_PLUGTS
- show dependent code
-
DBMS_RCVMAN
- show dependent code
-
DBMS_SPACE
- show dependent code
-
DBMS_STATS
- show dependent code
-
DBMS_STATS_INTERNAL
- show dependent code
-
DBMS_STATS_INTERNAL
- show dependent code
-
DBMS_TDB
- show dependent code
-
DBMS_TTS
- show dependent code
-
EXPMAPIOT
-
EXPPIOTMAP
-
EXU10DOSO
-
EXU10TABS
-
EXU112DLOB
-
EXU11IND_BASE
-
EXU7BSZ
-
EXU7CLU
-
EXU7IND
-
EXU7RSG
-
EXU7TAB
-
EXU7TBS
-
EXU7TSQ
-
EXU7USCU
-
EXU7USR
-
EXU81FIL
-
EXU81IXCP
-
EXU81IXSP
-
EXU81LBCP
-
EXU81LBP
-
EXU81LBSP
-
EXU81PLB
-
EXU81TBCP
-
EXU81TBS
-
EXU81TBSP
-
EXU81TTS
-
EXU8BSZ
-
EXU8CLU
-
EXU8IOV
-
EXU8IXP
-
EXU8LOB
-
EXU8NTB
-
EXU8OID
-
EXU8PDS
-
EXU8RSG
-
EXU8STO
-
EXU8TBP
-
EXU8TNE
-
EXU8TNEB
-
EXU8TSN
-
EXU8TSQ
-
EXU8USCU
-
EXU8USR
-
EXU92TSP
-
EXU92TSPL
-
EXU9FIL
-
EXU9IXCP
-
EXU9LBCP
-
EXU9LBP
-
EXU9LOB
-
EXU9LTTS
-
EXU9PDS
-
EXU9PLB
-
EXU9STO
-
EXU9TBCP
-
EXU9TBS
-
EXU9TSQ
-
IMP_LOB_INFO
-
INT$DBA_CLUSTERS
-
KU$_10_2_FHTABLE_VIEW
-
KU$_ACPTABLE_VIEW
-
KU$_ALL_INDEX_VIEW
-
KU$_BYTES_ALLOC_VIEW
-
KU$_CLUSTER_VIEW
-
KU$_CLU_TS_VIEW
-
KU$_EQNTABLE_DATA_VIEW
-
KU$_FHTABLE_VIEW
-
KU$_FILE_VIEW
-
KU$_HNTP_VIEW
-
KU$_HNT_VIEW
-
KU$_HTABLE_DATA_VIEW
-
KU$_HTABLE_VIEW
-
KU$_HTPART_DATA_VIEW
-
KU$_HTSPART_DATA_VIEW
-
KU$_IND_COMPART_VIEW
-
KU$_IND_PART_VIEW
-
KU$_IND_SUBNAME_VIEW
-
KU$_IND_SUBPART_VIEW
-
KU$_INSERT_TS_VIEW
-
KU$_IONT_VIEW
-
KU$_IOTABLE_DATA_VIEW
-
KU$_IOTABLE_VIEW
-
KU$_IOTPART_DATA_VIEW
-
KU$_LOBCOMPPART_VIEW
-
KU$_LOBFRAGINDEX_VIEW
-
KU$_LOBFRAG_VIEW
-
KU$_LOBINDEX_VIEW
-
KU$_LOB_VIEW
-
KU$_MAP_TABLE_VIEW
-
KU$_NIOTABLE_DATA_VIEW
-
KU$_NTABLE_DATA_VIEW
-
KU$_OIDINDEX_VIEW
-
KU$_OV_TABLE_VIEW
-
KU$_OV_TABPART_VIEW
-
KU$_PARTLOB_VIEW
-
KU$_PARTOBJ_VIEW
-
KU$_PFHTABLE_VIEW
-
KU$_PHTABLE_VIEW
-
KU$_PIOTABLE_VIEW
-
KU$_PIOTLOBFRAG_VIEW
-
KU$_PIOT_PART_VIEW
-
KU$_PLUGTS_TSNAME_FULL_VIEW
-
KU$_PLUGTS_TSNAME_VIEW
-
KU$_QTAB_STORAGE_VIEW
-
KU$_SUBLOBFRAGINDEX_VIEW
-
KU$_SUBLOBFRAG_VIEW
-
KU$_TABLESPACE_VIEW
-
KU$_TAB_COMPART_VIEW
-
KU$_TAB_PART_VIEW
-
KU$_TAB_SUBNAME_VIEW
-
KU$_TAB_SUBPART_VIEW
-
KU$_TAB_TSUBPART_VIEW
-
KU$_TBS_ILM_POLICY_VIEW
-
KU$_TLOB_COMPPART_VIEW
-
KU$_TSQUOTA_VIEW
-
KU$_TTSP_INDPARTVIEW
-
KU$_TTSP_INDSUBPARTVIEW
-
KU$_TTS_IDXVIEW
-
KU$_TTS_INDPARTVIEW
-
KU$_TTS_INDSUBPARTVIEW
-
KU$_TTS_IND_VIEW
-
KU$_TTS_MVL_VIEW
-
KU$_TTS_MV_VIEW
-
KU$_TTS_PARTLOBVIEW
-
KU$_TTS_SUBPARTLOBVIEW
-
KU$_TTS_TABPARTVIEW
-
KU$_TTS_TABSUBPARTVIEW
-
KU$_TTS_TABVIEW
-
KU$_TTS_VIEW
-
KU$_USER_BASE_VIEW
-
LOGMNR_DICT_CACHE
- show dependent code
-
LOGMNR_KRVRDLUID3
- show dependent code
-
PRVT_ILM
- show dependent code
-
SYSFILES
-
SYS_DBA_SEGS
-
SYS_UNCOMPRESSED_SEGS_BASE
-
SYS_USER_SEGS
-
TABQUOTAS
-
TS_PITR_INFO
-
TS_PLUG_INFO
-
USER_FREE_SPACE
-
USER_ILMDATAMOVEMENTPOLICIES
-
USER_ILMOBJECTS
-
USER_ILMPOLICIES
-
USER_INDEXES
-
USER_IND_PARTITIONS
-
USER_IND_SUBPARTITIONS
-
USER_LOBS
-
USER_LOB_PARTITIONS
-
USER_LOB_SUBPARTITIONS
-
USER_LOB_TEMPLATES
-
USER_OBJECT_TABLES
-
USER_PART_INDEXES
-
USER_PART_LOBS
-
USER_PART_TABLES
-
USER_RECYCLEBIN
-
USER_SUBPARTITION_TEMPLATES
-
USER_TABLES
-
USER_TABLESPACES
-
USER_TAB_PARTITIONS
-
USER_TAB_SUBPARTITIONS
-
USER_TS
-
USER_TS_QUOTAS
-
USER_USERS
-
WRI$_ADV_OBJSPACE_TREND_T
-
_utl$_gnp_ind
-
_utl$_gp_ind_parts
-
_utl$_lc_ind_subs
-
_utl$_lnc_ind_parts