EXA_DBA_VIRTUAL_SCHEMAS

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