Cache Table Recreation¶

The view’s cache table can be recreated using the ALTER [TABLE | VIEW] <view_name> CACHE RECREATE sentence (see section Modifying a Derived View).

The command executes the following steps:

1. Deletes the current cache table.

2. Creates a new cache table using the table creation template configured on the view or the cache data source. Note that the current cache table creation template may be different from the template used to create the old cache table deleted in the previous step.

The next sentence recreates the cache for the sampleView view:

ALTER VIEW sampleView CACHE RECREATE;

Privileges Required

To execute this command, the user needs these privileges:

• Connect over the database of the view.

• Write over the view.

• Connect over the database of the JDBC cache data source.

• Execute and Write over the JDBC cache data source.