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_PC_BLK_TABLE

Object Details

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

Unique Key: SYS_C00236193

SYS_NC_OID$

Indexes

Index	Type	Uniqueness	Tablespace	Column
SYS_C00236193	NORMAL	UNIQUE	SYSTEM	SYS_NC_OID$
SYS_IL0000489424C00011$$	LOB	UNIQUE	SYSTEM
SYS_IL0000489424C00012$$	LOB	UNIQUE	SYSTEM
SYS_IL0000489424C00023$$	LOB	UNIQUE	SYSTEM

Columns

Name	Datatype	Length
OBJ_ID	NUMBER
BLK_ID	NUMBER
BLK_EXTENT	SDO_GEOMETRY	(1)
BLK_DOMAIN	SDO_ORGSCL_TYPE	(1)
PCBLK_MIN_RES	NUMBER
PCBLK_MAX_RES	NUMBER
NUM_POINTS	NUMBER
NUM_UNSORTED_POINTS	NUMBER
PT_SORT_DIM	NUMBER
POINTS	BLOB	(4000)

Query Text

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


SELECT OBJ_ID
,      BLK_ID
,      BLK_EXTENT
,      BLK_DOMAIN
,      PCBLK_MIN_RES
,      PCBLK_MAX_RES
,      NUM_POINTS
,      NUM_UNSORTED_POINTS
,      PT_SORT_DIM
,      POINTS
FROM MDSYS.SDO_PC_BLK_TABLE;

Dependencies

[top of page]

MDSYS.SDO_PC_BLK_TABLE references the following:

MDSYS: SDO_ELEM_INFO_ARRAY; SDO_GEOMETRY; SDO_ORDINATE_ARRAY; SDO_ORGSCL_TYPE; SDO_PC_BLK; SDO_VPOINT_TYPE
SYS: STANDARD - show dependent code

MDSYS.SDO_PC_BLK_TABLE is not referenced by any database object