ENFORCE_OBJECT_STORAGE_POLICY
Applies object storage policies immediately, instead of waiting for the Tuple Mover to perform the next moveout. Calling this function is equivalent to setting the enforce_storage_move
parameter on related meta-functions. You typically use this function as the last step before dropping a storage location.
This function invokes the Tuple Mover on a one-time basis.
Syntax
ENFORCE_OBJECT_STORAGE_POLICY ( '
object_name', [, 'key_min', 'key_max'] )
Parameters
object_name |
Identifies the database object whose storage policies are to be applied. The object_name parameter can resolve to a database, schema, or table. |
key_min, key_max |
Applicable only when object_name is a table, key_min and key_max specify the table partition key value range over which to perform the moves. |
Privileges
Must be the object owner to enforce the storage policy and have access to the storage location.
Examples
This example shows how to apply storage-policy updates to the test
table:
=> select enforce_object_storage_policy("test");