Lists all virtual schemas and shows the properties which are specific to virtual schemas. Only users with the SELECT ANY DICTIONARY system privilege have access.
Virtual schemas are also listed in the table EXA_DBA_SCHEMAS.
| Column Name | Description |
|---|---|
SCHEMA_NAME
|
Name of the virtual schema |
SCHEMA_OWNER
|
Owner of the virtual schema |
SCHEMA_OBJECT_ID
|
ID of the virtual schema object |
ADAPTER_SCRIPT_SCHEMA
|
Schema containing the adapter script used for this virtual schema |
ADAPTER_SCRIPT_NAME
|
Name of the adapter script used for this virtual schema |
LAST_REFRESH
|
Timestamp of the last metadata refresh |
LAST_REFRESH_BY
|
Name of the user that performed the last metadata refresh |
ADAPTER_NOTES
|
The adapter can store additional information about the schema in this field |
