Related Documentation Download this Manual
PDF (US Ltr) - 0.6Mb
PDF (A4) - 0.6Mb


HeatWave User Guide  /  ...  /  The rpd_tables Table

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