EXA_VIRTUAL_SCHEMAS

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