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


TABLE: MDSYS.SDO_PREFERRED_OPS_USER

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

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: PREFERRED_OPS_USE_PRIM
  1. ColumnUSE_CASE
  2. ColumnSOURCE_SRID
  3. ColumnTARGET_SRID
Indexes
Index Type Uniqueness Tablespace Column
PREFERRED_OPS_USE_PRIM NORMAL UNIQUE TablespaceSYSTEM ColumnUSE_CASE
ColumnSOURCE_SRID
ColumnTARGET_SRID
Columns
Name Datatype Length Mandatory Comments
USE_CASE VARCHAR2 (32) Yes
SOURCE_SRID NUMBER (10) Yes
COORD_OP_ID NUMBER (10) Yes
TARGET_SRID NUMBER (10) Yes
Query Text

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


SELECT USE_CASE
,      SOURCE_SRID
,      COORD_OP_ID
,      TARGET_SRID
FROM MDSYS.SDO_PREFERRED_OPS_USER;

Dependencies

[top of page]

MDSYS.SDO_PREFERRED_OPS_USER does not reference any database object

MDSYS.SDO_PREFERRED_OPS_USER is referenced by following:

SchemaMDSYS
Package BodySDO_CS - show dependent code
TriggerSDO_PREFERRED_OPS_USER_TRIGGER
SchemaPUBLIC
SynonymSDO_PREFERRED_OPS_USER