EXA_ALL_VIRTUAL_TABLES
Lists all virtual tables to which the current user has access. It contains the information which are specific to virtual tables. All users have access to the table.
Virtual tables are also listed in the table EXA_ALL_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 |