Oracle® TimesTen In-Memory Database SQL Reference Release 11.2.1 Part Number E13070-03 |
|
|
View PDF |
The VIEWS table stores the statistics for views in the data store.
Columns
Column name | Type | Description |
---|---|---|
NAME | TT_CHAR(31) NOT NULL | View name. |
OWNER | TT_CHAR(31) NOT NULL | View owner. |
ID | TT_INTEGER NOT NULL for 32-bit systems;
TT_BIGINT NOT NULL for 64-bit systems |
ID of the view row. |
TBLID | TT_INTEGER NOT NULL for 32-bit systems;
TT_BIGINT NOT NULL for 64-bit systems |
ID of the view. |
SQL | TT_VARCHAR (409600) NOT NULL NOT INLINE | View select statement. |
REFRESH_INTERVAL | TT_BIGINT | Refresh interval in seconds |
REFRESH_START | TT_TIMESTAMP | The start time of the most recent refresh |
REFRESH_END | TT_TIMESTAMP | The ending time of the most recent refresh |
REFRESH_ROWCNT | TT_INTEGER | Number of rows refreshed in the most recent refresh |