Clearing PROJECTION_REFRESHES History
Information about a refresh operation—whether successful or unsuccessful—is maintained in system table PROJECTION_REFRESHES
until the function CLEAR_PROJECTION_REFRESHES
executes or the storage quota for the table is exceeded. The table's IS_EXECUTING
column returns a boolean value that indicates whether the refresh is running now (t) or occurred earlier (f).
To immediately purge this information, use the CLEAR_PROJECTION_REFRESHES() function:
=> SELECT clear_projection_refreshes(); clear_projection_refreshes ---------------------------- CLEAR (1 row)
Note: Only the rows where the PROJECTION_REFRESHES.IS_EXECUTING
column equals false are cleared.