[Home] [Help]
[Dependency Information]
TABLE: SYS.OPQTYPE$
Object Details
Object Name: | OPQTYPE$ |
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_OPQTYPE1
|
NORMAL
|
UNIQUE
|
SYSTEM
|
OBJ#
INTCOL#
|
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
OBJ# |
NUMBER |
|
Yes |
|
INTCOL# |
NUMBER |
|
Yes |
|
TYPE |
NUMBER |
|
|
|
FLAGS |
NUMBER |
|
|
|
LOBCOL |
NUMBER |
|
|
|
OBJCOL |
NUMBER |
|
|
|
EXTRACOL |
NUMBER |
|
|
|
SCHEMAOID |
RAW |
(16) |
|
|
ELEMNUM |
NUMBER |
|
|
|
SCHEMAURL |
VARCHAR2 |
(4000) |
|
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT OBJ#
, INTCOL#
, TYPE
, FLAGS
, LOBCOL
, OBJCOL
, EXTRACOL
, SCHEMAOID
, ELEMNUM
, SCHEMAURL
FROM SYS.OPQTYPE$;
Dependencies
[top of page]
SYS.OPQTYPE$ does not reference any database object
SYS.OPQTYPE$ is referenced by following:
-
SYS
-
ALL_XMLTYPE_COLS
-
ALL_XML_OUT_OF_LINE_TABLES
-
ALL_XML_TABLES
-
ALL_XML_TAB_COLS
-
ALL_XML_VIEWS
-
ALL_XML_VIEW_COLS
-
DBA_STREAMS_COLUMNS
-
DBA_XMLTYPE_COLS
-
DBA_XML_OUT_OF_LINE_TABLES
-
DBA_XML_TABLES
-
DBA_XML_TAB_COLS
-
DBA_XML_VIEWS
-
DBA_XML_VIEW_COLS
-
DBMS_FEATURE_PARTITION_SYSTEM
- show dependent code
-
DBMS_FEATURE_PARTITION_USER
- show dependent code
-
DBMS_LOGMNR_INTERNAL
- show dependent code
-
DBMS_METADATA_UTIL
- show dependent code
-
DBMS_REPCAT_FLA_UTL
- show dependent code
-
DBMS_REPCAT_OBJ_UTL
- show dependent code
-
DBMS_REPCAT_UTL
- show dependent code
-
DBMS_REPCAT_UTL2
- show dependent code
-
EXU10TABS
-
EXU112DLOB
-
EXU11XML
-
EXU9LOB
-
EXU9PLB
-
EXU9XMLST
-
KU$_10_2_FHTABLE_VIEW
-
KU$_ACPTABLE_VIEW
-
KU$_COLUMN_VIEW
-
KU$_EQNTABLE_DATA_VIEW
-
KU$_FHTABLE_VIEW
-
KU$_HTABLE_DATA_VIEW
-
KU$_HTPART_DATA_VIEW
-
KU$_HTSPART_DATA_VIEW
-
KU$_IOTABLE_DATA_VIEW
-
KU$_IOTABLE_VIEW
-
KU$_IOTPART_DATA_VIEW
-
KU$_NIOTABLE_DATA_VIEW
-
KU$_NTABLE_DATA_VIEW
-
KU$_OPQTYPE_VIEW
-
KU$_PCOLUMN_VIEW
-
KU$_PFHTABLE_VIEW
-
KU$_PIOTABLE_VIEW
-
KU$_PRIM_COLUMN_VIEW
-
KU$_STRMCOLTYPE_VIEW
-
KU$_STRMCOL_VIEW
-
KU$_STRMTABLE_VIEW
-
KU$_TABLE_XMLSCHEMA_VIEW
-
KU$_UNLOAD_METHOD_VIEW
-
LOGMNR_DICT_CACHE
- show dependent code
-
LOGMNR_GTCS_CAT_SUPPORT
-
LOGSTDBY_RU_UNSUPPORT_TAB_12_1
-
LOGSTDBY_SUPPORT_TAB_11_1
-
LOGSTDBY_SUPPORT_TAB_11_2
-
LOGSTDBY_SUPPORT_TAB_11_2B
-
LOGSTDBY_SUPPORT_TAB_12_1
-
LOGSTDBY_UNSUPPORT_TAB_11_1
-
LOGSTDBY_UNSUPPORT_TAB_11_2
-
LOGSTDBY_UNSUPPORT_TAB_11_2B
-
LOGSTDBY_UNSUPPORT_TAB_12_1
-
USER_XML_COLUMN_NAMES
-
USER_XML_TABLES
-
USER_XML_TAB_COLS
-
USER_XML_VIEWS
-
USER_XML_VIEW_COLS
-
XDB_MIGRATESCHEMA
- show dependent code
-
_DBA_STREAMS_UNSUPPORTED_10_2
-
_DBA_STREAMS_UNSUPPORTED_11_1
-
_DBA_STREAMS_UNSUPPORTED_11_2
-
_DBA_STREAMS_UNSUPPORTED_12_1