DBA Data[Home] [Help] [Dependency Information]


TABLE: MDSYS.SDO_TIN_PC_SYSDATA_TABLE

Object Details
Object Name: SDO_TIN_PC_SYSDATA_TABLE
Object Type: TABLE
Owner: MDSYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: SDO_PK_TIN_PC
  1. ColumnDEP_TABLE_SCHEMA
  2. ColumnDEP_TABLE_NAME
Unique Key: SDO_UNQ_PCATTR_TIN_PC
  1. ColumnSDO_OWNER
  2. ColumnTABLE_NAME
  3. ColumnCOLUMN_NAME
  4. ColumnDEP_TABLE_SCHEMA
  5. ColumnDEP_TABLE_NAME
Indexes
Index Type Uniqueness Tablespace Column
SDO_PK_TIN_PC NORMAL UNIQUE TablespaceSYSTEM ColumnDEP_TABLE_SCHEMA
ColumnDEP_TABLE_NAME
SDO_UNQ_PCATTR_TIN_PC NORMAL UNIQUE TablespaceSYSTEM ColumnSDO_OWNER
ColumnTABLE_NAME
ColumnCOLUMN_NAME
ColumnDEP_TABLE_SCHEMA
ColumnDEP_TABLE_NAME
SDO_TIN_PC_IDX NORMAL NONUNIQUE TablespaceSYSTEM ColumnSDO_OWNER
ColumnTABLE_NAME
ColumnCOLUMN_NAME
Columns
Name Datatype Length Mandatory Comments
SDO_OWNER VARCHAR2 (32) Yes
TABLE_NAME VARCHAR2 (32) Yes
COLUMN_NAME VARCHAR2 (1024) Yes
DEP_TABLE_SCHEMA VARCHAR2 (32) Yes
DEP_TABLE_NAME VARCHAR2 (32) Yes
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SDO_OWNER
,      TABLE_NAME
,      COLUMN_NAME
,      DEP_TABLE_SCHEMA
,      DEP_TABLE_NAME
FROM MDSYS.SDO_TIN_PC_SYSDATA_TABLE;

Dependencies

[top of page]

MDSYS.SDO_TIN_PC_SYSDATA_TABLE does not reference any database object

MDSYS.SDO_TIN_PC_SYSDATA_TABLE is referenced by following:

SchemaMDSYS
ViewALL_SDO_TIN_PC_SYSDATA
Package BodyPRVTTNPC - show dependent code