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 |