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 | 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 |