EXA_DBA_VIRTUAL_TABLES

This system table lists all virtual tables and contains the information which are specific to virtual tables. Only users with the system privilege SELECT ANY DICTIONARY have access to the table.

Virtual tables are also listed in the table EXA_DBA_TABLES.

Column Name Description
TABLE_SCHEMA Name of the virtual schema containing the virtual table
TABLE_NAME Name of the virtual table
TABLE_OBJECT_ID ID of the virtual table
LAST_REFRESH Timestamp of the last metadata refresh (when metadata was committed)
LAST_REFRESH_BY Name of the user that performed the last metadata refresh
ADAPTER_NOTES The adapter can store additional information about the table in this field