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.
xxx_SDO_3DTHEMES Views
The USER_SDO_3DTHEMES and ALL_SDO_3DTHEMES views have the columns listed in Table: xxx_SDO_3DTHEMES Views.
Table: 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 |
xxx_SDO_SCENES Views
The USER_SDO_SCENES and ALL_SDO_SCENES views have the columns listed in Table: xxx_SDO_SCENES Views.
Table: 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 |
xxx_SDO_VIEWFRAMES Views
The USER_SDO_VIEWFRAMES and ALL_SDO_VIEWFRAMES views have the columns listed in Table: xxx_SDO_VIEWFRAMES Views.
Table: 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 |