[Home] [Help]
[Dependency Information]
TABLE: MDSYS.CSW_RECORD_TYPES$
Object Details
| Object Name: | CSW_RECORD_TYPES$ |
|---|
| Object Type: | TABLE |
|---|
| Owner: | MDSYS |
|---|
| Subobject Name: | |
|---|
| Status: | VALID |
|---|
Storage Details
| Tablespace: |  SYSTEM |
|---|
| PCT Free: | 10 |
|---|
| PCT Used: | 40 |
|---|
Primary Key: SYS_C00236188
-
RECORDTYPEID
Unique Key: UNIQUE_CSW_RT_COND
- TYPENAMENS
- TYPENAME
Indexes
| Index |
Type |
Uniqueness |
Tablespace |
Column |
|
SYS_C00236188
|
NORMAL
|
UNIQUE
|
SYSTEM
|
RECORDTYPEID
|
|
SYS_IL0000489364C00005$$
|
LOB
|
UNIQUE
|
SYSTEM
|
|
|
SYS_IL0000489364C00007$$
|
LOB
|
UNIQUE
|
SYSTEM
|
|
|
SYS_IL0000489364C00008$$
|
LOB
|
UNIQUE
|
SYSTEM
|
|
|
SYS_IL0000489364C00009$$
|
LOB
|
UNIQUE
|
SYSTEM
|
|
|
SYS_IL0000489364C00012$$
|
LOB
|
UNIQUE
|
SYSTEM
|
|
|
SYS_IL0000489364C00014$$
|
LOB
|
UNIQUE
|
SYSTEM
|
|
|
SYS_IL0000489364C00016$$
|
LOB
|
UNIQUE
|
SYSTEM
|
|
|
SYS_IL0000489364C00017$$
|
LOB
|
UNIQUE
|
SYSTEM
|
|
|
SYS_IL0000489364C00021$$
|
LOB
|
UNIQUE
|
SYSTEM
|
|
|
SYS_IL0000489364C00022$$
|
LOB
|
UNIQUE
|
SYSTEM
|
|
|
SYS_IL0000489364C00023$$
|
LOB
|
UNIQUE
|
SYSTEM
|
|
|
SYS_IL0000489364C00027$$
|
LOB
|
UNIQUE
|
SYSTEM
|
|
|
SYS_IL0000489364C00028$$
|
LOB
|
UNIQUE
|
SYSTEM
|
|
|
SYS_IL0000489364C00029$$
|
LOB
|
UNIQUE
|
SYSTEM
|
|
|
UNIQUE_CSW_RT_COND
|
NORMAL
|
UNIQUE
|
SYSTEM
|
TYPENAMENS
TYPENAME
|
Foreign Keys
| Table |
|
Foreign Table |
Foreign Key Column |
 CSW_DOMAININFO$
|
 |
CSW_RECORD_TYPES$
|
CSW_DOMAININFO$
RECORDTYPEID
|
Columns
| Name |
Datatype |
Length |
Mandatory |
Comments |
| RECORDTYPEID |
NUMBER |
|
Yes |
|
| TYPENAME |
VARCHAR2 |
(80) |
|
|
| TYPENAMENS |
VARCHAR2 |
(2083) |
|
|
| DESCRIBERECORD |
XMLTYPE |
(2000) |
|
|
| DATAPOINTER |
VARCHAR2 |
(61) |
|
|
| IDPATHS |
STRINGLIST |
(3752) |
|
|
| SPATIALPATHS |
STRINGLIST |
(3752) |
|
|
| TSPATHS |
STRINGLIST |
(3752) |
|
|
| LASTUPDATETS |
TIMESTAMP(6) |
(11) |
|
|
| BRIEFXSLPATTERN |
XMLTYPE |
(2000) |
|
|
| SUMMARYXSLPATTERN |
XMLTYPE |
(2000) |
|
|
| DCMIXSLPATTERN |
XMLTYPE |
(2000) |
|
|
| SRSPATHS |
STRINGLIST |
(3752) |
|
|
| SRSNS |
VARCHAR2 |
(2083) |
|
|
| SRSNSALIAS |
VARCHAR2 |
(80) |
|
|
| RTXSDREFID |
VARCHAR2 |
(80) |
|
|
| NUMCOLS |
STRINGLIST |
(3752) |
|
|
| IDXPATHS |
STRINGLIST |
(3752) |
|
|
| IDXPATHTYPES |
STRINGLIST |
(3752) |
|
|
| XTIDXCREATED |
VARCHAR2 |
(1) |
|
|
| IDEXTRACTORTYPE |
VARCHAR2 |
(20) |
|
|
| ISGML3 |
VARCHAR2 |
(1) |
|
|
| SPATIALARRLIST |
STRINGLISTLIST |
(3752) |
|
|
| SPATIALPATHSSRSNSLIST |
STRINGLISTLIST |
(3752) |
|
|
| SPATIALARRPATHSSRSNSLIST |
STRINGLISTLIST |
(3752) |
|
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT RECORDTYPEID
, TYPENAME
, TYPENAMENS
, DESCRIBERECORD
, DATAPOINTER
, IDPATHS
, SPATIALPATHS
, TSPATHS
, LASTUPDATETS
, BRIEFXSLPATTERN
, SUMMARYXSLPATTERN
, DCMIXSLPATTERN
, SRSPATHS
, SRSNS
, SRSNSALIAS
, RTXSDREFID
, NUMCOLS
, IDXPATHS
, IDXPATHTYPES
, XTIDXCREATED
, IDEXTRACTORTYPE
, ISGML3
, SPATIALARRLIST
, SPATIALPATHSSRSNSLIST
, SPATIALARRPATHSSRSNSLIST
FROM MDSYS.CSW_RECORD_TYPES$;
Dependencies
[top of page]
MDSYS.CSW_RECORD_TYPES$ references the following:
-
MDSYS
-
STRINGLIST
-
STRINGLISTLIST
-
PUBLIC
-
XMLTYPE
-
SYS
-
STANDARD
- show dependent code
-
XMLTYPE
-
-
MDSYS.CSW_RECORD_TYPES$ is referenced by following:
-
MDSYS
-
SDO_CSW_PROCESS
- show dependent code