10.10.4 The rpd_tables Table

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.

• POOL_TYPE

  The load pool type of the table. Possible values are RAPID_LOAD_POOL_SNAPSHOT and RAPID_LOAD_POOL_TRANSACTIONAL.

• 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.

The rpd_tables table is read-only. DDL, including TRUNCATE TABLE, is not permitted.