Oracle Spatial and Graph uses the following other metadata views:
USER_SDO_3DTHEMES and ALL_SDO_3DTHEMES contain information about three-dimensional themes. These views are described in xxx_SDO_3DTHEMES Views.
USER_SDO_SCENES and ALL_SDO_SCENES contain information about scenes. These views are described in xxx_SDO_SCENES Views.
USER_SDO_VIEWFRAMES and ALL_SDO_VIEWFRAMES contain information about viewframes. These views are described in xxx_SDO_VIEWFRAMES Views.
The USER_SDO_xxx views contain metadata information about objects owned by the user (schema), and the ALL_SDO_xxx views contain metadata information about objects on which the user has SELECT permission.
The ALL_SDO_xxx views include an OWNER column that identifies the schema of the owner of the object. The USER_SDO_xxx views do not include an OWNER column.
The USER_SDO_3DTHEMES and ALL_SDO_3DTHEMES views have the columns listed in Table 2-8.
Table 2-8 xxx_SDO_3DTHEMES Views
| Column Name | Data Type | Description |
|---|---|---|
|
OWNER |
VARCHAR2(32) |
Schema that owns the theme (ALL_SDO_3DTHEMES only) |
|
NAME |
VARCHAR2(32) |
Unique name to be associated with the theme |
|
DESCRIPTION |
VARCHAR2(4000) |
Optional descriptive text about the theme |
|
BASE_TABLE |
VARCHAR2(64) |
Table or view containing the spatial geometry column |
|
THEME_COLUMN |
VARCHAR2(2048) |
Name of the theme column |
|
STYLE_COLUMN |
VARCHAR2(32) |
Name of the style column |
|
THEME_TYPE |
VARCHAR2(32) |
Theme type |
|
DEFINITION |
CLOB |
XML definition of the theme |
The USER_SDO_SCENES and ALL_SDO_SCENES views have the columns listed in Table 2-9.
Table 2-9 xxx_SDO_SCENES Views
| Column Name | Data Type | Description |
|---|---|---|
|
OWNER |
VARCHAR2(32) |
Schema that owns the scene (ALL_SDO_SCENES only) |
|
NAME |
VARCHAR2(32) |
Unique name to be associated with the scene |
|
DESCRIPTION |
VARCHAR2(4000) |
Optional descriptive text about the scene |
|
DEFINITION |
CLOB |
XML definition of the scene |
The USER_SDO_VIEWFRAMES and ALL_SDO_VIEWFRAMES views have the columns listed in Table 2-10.
Table 2-10 xxx_SDO_VIEWFRAMES Views
| Column Name | Data Type | Description |
|---|---|---|
|
OWNER |
VARCHAR2(32) |
Schema that owns the scene (ALL_SDO_VIEWFRAMES only) |
|
NAME |
VARCHAR2(32) |
Unique name to be associated with the viewframe |
|
DESCRIPTION |
VARCHAR2(4000) |
Optional descriptive text about the viewframe |
|
SCENE_NAME |
VARCHAR2(32) |
Name of the scene associated with the viewframe |
|
DEFINITION |
CLOB |
XML definition of the viewframe |