[Home] [Help]
[Dependency Information]
TABLE: SYS.PARTOBJ$
Object Details
Object Name: | PARTOBJ$ |
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_PARTOBJ$
|
NORMAL
|
UNIQUE
|
SYSTEM
|
OBJ#
|
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
OBJ# |
NUMBER |
|
Yes |
|
PARTTYPE |
NUMBER |
|
Yes |
|
PARTCNT |
NUMBER |
|
Yes |
|
PARTKEYCOLS |
NUMBER |
|
Yes |
|
FLAGS |
NUMBER |
|
|
|
DEFTS# |
NUMBER |
|
|
|
DEFPCTFREE |
NUMBER |
|
Yes |
|
DEFPCTUSED |
NUMBER |
|
Yes |
|
DEFPCTTHRES |
NUMBER |
|
|
|
DEFINITRANS |
NUMBER |
|
Yes |
|
DEFMAXTRANS |
NUMBER |
|
Yes |
|
DEFTINIEXTS |
NUMBER |
|
|
|
DEFEXTSIZE |
NUMBER |
|
|
|
DEFMINEXTS |
NUMBER |
|
|
|
DEFMAXEXTS |
NUMBER |
|
|
|
DEFEXTPCT |
NUMBER |
|
|
|
DEFLISTS |
NUMBER |
|
Yes |
|
DEFGROUPS |
NUMBER |
|
Yes |
|
DEFLOGGING |
NUMBER |
|
Yes |
|
SPARE1 |
NUMBER |
|
|
|
SPARE2 |
NUMBER |
|
|
|
SPARE3 |
NUMBER |
|
|
|
DEFINCLCOL |
NUMBER |
|
|
|
PARAMETERS |
VARCHAR2 |
(1000) |
|
|
DEFMAXSIZE |
NUMBER |
|
|
|
INTERVAL_STR |
VARCHAR2 |
(1000) |
|
|
INTERVAL_BIVAL |
RAW |
(200) |
|
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT OBJ#
, PARTTYPE
, PARTCNT
, PARTKEYCOLS
, FLAGS
, DEFTS#
, DEFPCTFREE
, DEFPCTUSED
, DEFPCTTHRES
, DEFINITRANS
, DEFMAXTRANS
, DEFTINIEXTS
, DEFEXTSIZE
, DEFMINEXTS
, DEFMAXEXTS
, DEFEXTPCT
, DEFLISTS
, DEFGROUPS
, DEFLOGGING
, SPARE1
, SPARE2
, SPARE3
, DEFINCLCOL
, PARAMETERS
, DEFMAXSIZE
, INTERVAL_STR
, INTERVAL_BIVAL
FROM SYS.PARTOBJ$;
Dependencies
[top of page]
SYS.PARTOBJ$ does not reference any database object
SYS.PARTOBJ$ is referenced by following:
-
SYS
-
ALL_IND_STATISTICS
-
ALL_LOBS
-
ALL_LOB_PARTITIONS
-
ALL_LOB_SUBPARTITIONS
-
ALL_PART_INDEXES
-
ALL_PART_TABLES
-
DBA_IND_STATISTICS
-
DBA_LOBS
-
DBA_LOB_PARTITIONS
-
DBA_LOB_SUBPARTITIONS
-
DBA_PART_INDEXES
-
DBA_PART_TABLES
-
DBA_STREAMS_COLUMNS
-
DBMSOBJG2
- show dependent code
-
DBMS_FEATURE_PARTITION_SYSTEM
- show dependent code
-
DBMS_FEATURE_PARTITION_USER
- show dependent code
-
DBMS_LOGMNR_INTERNAL
- show dependent code
-
DBMS_METADATA_INT
- show dependent code
-
DBMS_METADATA_UTIL
- show dependent code
-
DBMS_STATS
- show dependent code
-
DBMS_STATS_INTERNAL
- show dependent code
-
DBMS_STATS_INTERNAL
- show dependent code
-
EXPPIOTMAP
-
EXPTABSUBPARTDATA_VIEW
-
EXU81LBSP
-
EXU9DOI
-
EXU9LBCP
-
EXU9LBP
-
EXU9PDS
-
KU$_2NDTAB_INFO_VIEW
-
KU$_ACPTABLE_VIEW
-
KU$_DOMIDX_PLSQL_VIEW
-
KU$_HTPART_DATA_VIEW
-
KU$_HTSPART_DATA_VIEW
-
KU$_IOTPART_DATA_VIEW
-
KU$_PARTOBJ_VIEW
-
KU$_PFHTABLE_VIEW
-
KU$_PFHTABPROP_VIEW
-
KU$_PHTABLE_VIEW
-
KU$_REFPARTTABPROP_VIEW
-
KU$_REFPAR_LEVEL
-
KU$_REF_PAR_LEVEL_VIEW
-
KU$_TEMP_SUBPARTDATA_VIEW
-
KU$_TTSP_INDPARTVIEW
-
KU$_TTSP_INDSUBPARTVIEW
-
LOADER_PART_INFO
-
LOGMNR_DICT_CACHE
- show dependent code
-
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
-
STRADDLING_TS_OBJECTS
-
TTS_TAB_VIEW
-
USER_IND_STATISTICS
-
USER_LOBS
-
USER_LOB_PARTITIONS
-
USER_LOB_SUBPARTITIONS
-
USER_PART_INDEXES
-
USER_PART_TABLES
-
_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
-
_utl$_gp_ind_parts
-
_utl$_lc_ind_subs
-
_utl$_lnc_ind_parts