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

TABLE: MDSYS.SDO_GR_RDT_1

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

Temporary Table Details

MDSYS.SDO_GR_RDT_1 is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.

Storage Details
Tablespace: Tablespace
PCT Free: 10
PCT Used: 40
Primary Key: SDO_GR_RDT_1_PK
  1. ColumnRASTERDATATABLE
  2. ColumnRASTERID
  3. ColumnPYRAMIDLEVEL
  4. ColumnBANDBLOCKNUMBER
  5. ColumnROWBLOCKNUMBER
  6. ColumnCOLUMNBLOCKNUMBER
Indexes
Index Type Uniqueness Tablespace Column
SDO_GR_RDT_1_PK NORMAL UNIQUE Tablespace ColumnRASTERDATATABLE
ColumnRASTERID
ColumnPYRAMIDLEVEL
ColumnBANDBLOCKNUMBER
ColumnROWBLOCKNUMBER
ColumnCOLUMNBLOCKNUMBER
SYS_IL0000634963C00013$$ LOB UNIQUE TablespaceSYSTEM
SYS_IL0000634963C00014$$ LOB UNIQUE TablespaceSYSTEM
SYS_IL0000634963C00015$$ LOB UNIQUE TablespaceSYSTEM
Columns
Name Datatype Length Mandatory Comments
RASTERDATATABLE VARCHAR2 (100) Yes
RASTERID NUMBER
Yes
PYRAMIDLEVEL NUMBER
Yes
BANDBLOCKNUMBER NUMBER
Yes
ROWBLOCKNUMBER NUMBER
Yes
COLUMNBLOCKNUMBER NUMBER
Yes
BLOCKMBR SDO_GEOMETRY (1)
RASTERBLOCK BLOB (4000)
Query Text

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


SELECT RASTERDATATABLE
,      RASTERID
,      PYRAMIDLEVEL
,      BANDBLOCKNUMBER
,      ROWBLOCKNUMBER
,      COLUMNBLOCKNUMBER
,      BLOCKMBR
,      RASTERBLOCK
FROM MDSYS.SDO_GR_RDT_1;

Dependencies

[top of page]

MDSYS.SDO_GR_RDT_1 references the following:

SchemaMDSYS
TYPESDO_ELEM_INFO_ARRAY
TYPESDO_GEOMETRY
TYPESDO_ORDINATE_ARRAY
SchemaSYS
PL/SQL PackageSTANDARD - show dependent code

MDSYS.SDO_GR_RDT_1 is not referenced by any database object