Enterprise Mode only
Applies storage policies of the specified object immediately. By default, the Tuple Mover enforces object storage policies after all pending mergeout operations are complete. Calling this function is equivalent to setting the enforce argument when using RETIRE_LOCATION. You typically use this function as the last step before dropping a storage location.
ENFORCE_OBJECT_STORAGE_POLICY ( 'object‑name' [,'key‑min', 'key‑max'] )
The database object whose storage policies are to be applied, one of the following:
In all cases, database must be the name of the current database.
Valid only if object‑name is a table, specifies the range of table partition key values on which to perform the move.
One of the following:
- Object owner and access to its storage location.
Apply storage policy updates to the
=> SELECT ENFORCE_OBJECT_STORAGE_POLICY ('test');