eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: MDSYS.SDO_GR_MOSAIC_0

Object Details

Object Name:	SDO_GR_MOSAIC_0
Object Type:	TABLE
Owner:	MDSYS
Subobject Name:
Status:	VALID

Temporary Table Details

MDSYS.SDO_GR_MOSAIC_0 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$SESSION. Data is removed at the end of this period.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Primary Key: SYS_C00278856

Indexes

Index	Type	Uniqueness	Tablespace	Column
SYS_C00278856	NORMAL	UNIQUE		ID
SYS_IL0001108128C00037$$	LOB	UNIQUE	SYSTEM
SYS_IL0001108128C00038$$	LOB	UNIQUE	SYSTEM
SYS_IL0001108128C00040$$	LOB	UNIQUE	SYSTEM

Columns

Name	Datatype	Length	Mandatory
RID	ROWID	(10)
RDT	VARCHAR2	(100)
RSTID	NUMBER
RSTYPE	NUMBER
SRID	NUMBER
RCTIF	VARCHAR2	(10)
R0	NUMBER
C0	NUMBER
B0	NUMBER
R1	NUMBER
C1	NUMBER
B1	NUMBER
BANDS	NUMBER
BCV	NUMBER
ILV	VARCHAR2	(5)
RBLKSZ	NUMBER
CBLKSZ	NUMBER
BBLKSZ	NUMBER
CDL	NUMBER
CDP	VARCHAR2	(50)
ULTR	NUMBER
ULTC	NUMBER
ULTB	NUMBER
RROWS	NUMBER
COLS	NUMBER
CPTYPE	VARCHAR2	(10)
ID	NUMBER		Yes
OP	NUMBER
NODATA_IND	NUMBER
DIST	NUMBER
EXTENT	SDO_GEOMETRY	(1)
META	XMLTYPE	(2000)

Query Text

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


SELECT RID
,      RDT
,      RSTID
,      RSTYPE
,      SRID
,      RCTIF
,      R0
,      C0
,      B0
,      R1
,      C1
,      B1
,      BANDS
,      BCV
,      ILV
,      RBLKSZ
,      CBLKSZ
,      BBLKSZ
,      CDL
,      CDP
,      ULTR
,      ULTC
,      ULTB
,      RROWS
,      COLS
,      CPTYPE
,      ID
,      OP
,      NODATA_IND
,      DIST
,      EXTENT
,      META
FROM MDSYS.SDO_GR_MOSAIC_0;

Dependencies

[top of page]

MDSYS.SDO_GR_MOSAIC_0 references the following:

MDSYS: SDO_ELEM_INFO_ARRAY; SDO_GEOMETRY; SDO_ORDINATE_ARRAY
PUBLIC: XMLTYPE
SYS: STANDARD - show dependent code; XMLTYPE

MDSYS.SDO_GR_MOSAIC_0 is referenced by following:

MDSYS: SDO_GEOR_AUX - show dependent code