CLEAR_DEPOT_PIN_POLICY_PARTITION

Eon Mode only

Clears a depot pinning policy from the specified table or projection partitions. After the object is unpinned, it can be evicted from the depot by any unpinned or pinned object..

Syntax

CLEAR_DEPOT_PIN_POLICY_PARTITION( '[[database.]schema.]object‑name', 'min‑range‑value', 'max‑range‑value' [, subcluster ] )

Parameters

[database.]schema

Specifies a schema, by default public. If schema is any schema other than public, you must supply the schema name. For example:

myschema.thisDbObject

If you specify a database, it must be the current database.
object‑name The table or projection with a partition pinning policy to clear.
min‑range‑value
max‑range‑value 		Clears a pinning policy from the specified range of partition keys in table, where min‑range‑value must be ≤ max‑range‑value. If the policy applies to a single partition, min‑range‑value and max‑range‑value must be equal.
subcluster Clears the specified pinning policy from the subcluster depot. If you omit this parameter, the policy is cleared from all database depots.

Privileges

Superuser

See Also