2.9 Other Spatial Metadata Views
Oracle Spatial uses the following other metadata views.
-
USER_SDO_3DTHEMES and ALL_SDO_3DTHEMES contain information about three-dimensional themes.
-
USER_SDO_SCENES and ALL_SDO_SCENES contain information about scenes.
-
USER_SDO_VIEWFRAMES and ALL_SDO_VIEWFRAMES contain information about viewframes.
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.
Parent topic: Spatial Data Types and Metadata
2.9.1 xxx_SDO_3DTHEMES Views
The USER_SDO_3DTHEMES and ALL_SDO_3DTHEMES views have the columns listed in Table 2-10.
Table 2-10 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 |
Parent topic: Other Spatial Metadata Views
2.9.2 xxx_SDO_SCENES Views
The USER_SDO_SCENES and ALL_SDO_SCENES views have the columns listed in Table 2-11.
Table 2-11 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 |
Parent topic: Other Spatial Metadata Views
2.9.3 xxx_SDO_VIEWFRAMES Views
The USER_SDO_VIEWFRAMES and ALL_SDO_VIEWFRAMES views have the columns listed in Table 2-12.
Table 2-12 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 |
Parent topic: Other Spatial Metadata Views