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
NAMPESPACE_NAME VARCHAR For Eon Mode databases, object namespace.
SCHEMA_NAME VARCHAR

Object schema.

If the schema belongs to a non-default namespace in an Eon Mode database, the schema name is front-qualified with the name of the schema's namespace. For example, n1.s refers to schema s in namespace n1.

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.