DEPOT_PIN_POLICIES

Lists all objects —tables, projections, and table partitions—with depot eviction policies.

Eon Mode only

Lists all objects —tables, projections, and table partitions—with depot eviction policies.

Column Name Data Type Description
SCHEMA_NAME VARCHAR Object schema.
OBJECT_NAME VARCHAR Object name.
SUBCLUSTER_NAME VARCHAR Name of the subcluster where the pinning policy is set, null if the policy is set on all database depots.
POLICY_DETAILS VARCHAR

Object type, one of the following:

  • Table

  • Projection

  • Partition

MIN_VAL VARCHAR If POLICY_DETAILS is set to Partition, the range of contiguous partition keys specified by this policy.
MAX_VAL
LOCATION_LABEL VARCHAR Depot's storage location label.
POLICY_TYPE VARCHAR Policy type set on this object (PIN or ANTI-PIN), if any.