The rpd_tables
table provides the system
change number (SCN) and load pool type for tables loaded in
HeatWave.
The rpd_tables
table has these columns:
-
ID
A unique identifier for the table.
-
SNAPSHOT_SCN
The system change number (SCN) of the table snapshot. The SCN is an internal number that represents a point in time according to the system logical clock that the table snapshot was transactionally consistent with the source table.
-
PERSISTED_SCN
The SCN up to which changes are persisted.
-
POOL_TYPE
The load pool type of the table. Possible values are
RAPID_LOAD_POOL_SNAPSHOT
andRAPID_LOAD_POOL_TRANSACTIONAL
. -
DATA_PLACEMENT_TYPE
The data placement type.
-
NROWS
The number of rows that are loaded for the table. The value is set initially when the table is loaded, and updated as changes are propagated.
-
LOAD_STATUS
The load status of the table. Statuses include:
-
NOLOAD_RPDGSTABSTATE
The table is not yet loaded.
-
LOADING_RPDGSTABSTATE
The table is being loaded.
-
AVAIL_RPDGSTABSTATE
The table is loaded and available for queries.
-
UNLOADING_RPDGSTABSTATE
The table is being unloaded.
-
INRECOVERY_RPDGSTABSTATE
The table is being recovered. After completion of the recovery operation, the table is placed back in the
UNAVAIL_RPDGSTABSTATE
state if there are pending recoveries. -
UNAVAIL_RPDGSTABSTATE
The table is unavailable.
-
-
LOAD_PROGRESS
The load progress of the table expressed as a percentage value.
-
SIZE_BYTES
The amount of data loaded for the table, in bytes.
-
QUERY_COUNT
The number of queries that referenced the table.
-
LAST_QUERIED
The timestamp of the last query that referenced the table.
-
LOAD_START_TIMESTAMP
The load start timestamp for the table.
-
LOAD_END_TIMESTAMP
The load completion timestamp for the table.
The rpd_tables
table is read-only.