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


TABLE: MDSYS.SDO_CACHED_MAPS_TABLE

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

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: UNIQUE_CACHED_MAPS
  1. ColumnSDO_OWNER
  2. ColumnNAME
Indexes
Index Type Uniqueness Tablespace Column
SYS_IL0000491718C00007$$ LOB UNIQUE TablespaceSYSTEM
SYS_IL0000491718C00009$$ LOB UNIQUE TablespaceSYSTEM
UNIQUE_CACHED_MAPS NORMAL UNIQUE TablespaceSYSTEM ColumnSDO_OWNER
ColumnNAME
Columns
Name Datatype Length Mandatory Comments
SDO_OWNER VARCHAR2 (32) Yes
NAME VARCHAR2 (32) Yes
DESCRIPTION VARCHAR2 (4000)
TILES_TABLE VARCHAR2 (32)
IS_ONLINE VARCHAR2 (3) Yes
IS_INTERNAL VARCHAR2 (4) Yes
DEFINITION CLOB (4000) Yes
BASE_MAP VARCHAR2 (32)
MAP_ADAPTER BLOB (4000)
Query Text

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


SELECT SDO_OWNER
,      NAME
,      DESCRIPTION
,      TILES_TABLE
,      IS_ONLINE
,      IS_INTERNAL
,      DEFINITION
,      BASE_MAP
,      MAP_ADAPTER
FROM MDSYS.SDO_CACHED_MAPS_TABLE;

Dependencies

[top of page]

MDSYS.SDO_CACHED_MAPS_TABLE does not reference any database object

MDSYS.SDO_CACHED_MAPS_TABLE is referenced by following:

SchemaMDSYS
ViewALL_SDO_CACHED_MAPS
ViewUSER_SDO_CACHED_MAPS