CLEAR_OBJECT_STORAGE_POLICY

Removes an existing storage policy. The specified object will no longer use a user-created storage location. Any existing data stored currently at the labeled location in the object's storage policy is moved to default storage during the next TM moveout operation.

Syntax

CLEAR_OBJECT_STORAGE_POLICY ( 'object_name' [,'key_min', 'key_max'] [, 'enforce_storage_move' ]  )

Parameters

object_name

Identifies the database object whose storage policies are to be cleared. The object_name parameter can resolve to a database, schema, or table. 

key_min, key_max

[Optional] Specifies the table partition key value ranges stored at the labeled location. These parameters are applicable only when object_name is a table. 

enforce_storage_move

[Optional] If true, moves the storage containers that belong to this object to the new location immediately. If false (the default), this move occurs automatically sometime after the next moveout operation.

Privileges

Superuser

Examples

This example shows how to clear the storage policy for the object lineorder. Changes take effect after the next moveout:

=> select clear_object_storage_policy('lineorder');
      clear_object_storage_policy       
-----------------------------------
 Default storage policy cleared.
(1 row)

See Also