CLEAR_OBJECT_STORAGE_POLICY
Removes a user-defined storage policy from the specified database, schema or table. Storage containers at the previous policy's labeled location are moved to the default location. By default, this move occurs after all pending mergeout tasks return.
Syntax
CLEAR_OBJECT_STORAGE_POLICY ( 'object‑name' [,'key‑min', 'key‑max'] [, 'enforce‑storage‑move' ] )
Parameters
object‑name |
The object to clear, one of the following:
In all cases, database must be the name of the current database. |
key‑min
|
Valid only if object‑name is a table, specifies the range of table partition key values stored at the labeled location. |
enforce‑storage‑move |
Specifies when the Tuple Mover moves all existing storage containers for the specified object to its default storage location:
You can also enforce all storage policies immediately by calling Vertica meta-function |
Privileges
Superuser
Examples
This following statement clears the storage policy for table store.store_orders_fact
. The true
argument specifies to implement the move immediately:
=> SELECT CLEAR_OBJECT_STORAGE_POLICY ('store.store_orders_fact', 'true'); CLEAR_OBJECT_STORAGE_POLICY ----------------------------------------------------------------------------- Object storage policy cleared. Task: moving storages (Table: store.store_orders_fact) (Projection: store.store_orders_fact_b0) (Table: store.store_orders_fact) (Projection: store.store_orders_fact_b1) (1 row)