rpd_tables table provides the system
change number (SCN) and load pool type for tables loaded in
rpd_tables table has these columns:
A unique identifier for the table.
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.
The load pool type of the table. Possible values are
The load status of the table. Statuses include:
The table is not yet loaded.
The table is being loaded.
The table is loaded and available for queries.
The table is being unloaded.
The table is being recovered. After completion of the recovery operation, the table is placed back in the
UNAVAIL_RPDGSTABSTATEstate if there are pending recoveries.
The table is unavailable.
rpd_tables table is read-only. DDL,
TRUNCATE TABLE, is not