Lists all virtual schemas to which the current user has access and shows the properties which are specific to virtual schemas (identical to EXA_ALL_VIRTUAL_SCHEMAS). All users have access to the table.
Virtual schemas are also listed in the table EXA_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 |
