Updated on 2024-06-03 GMT+08:00

GS_ADM_ILMOBJECTS

GS_ADM_ILMOBJECTS displays the brief information about all data objects to which ILM policies are applied and the corresponding policies, including the policy name, data object name, policy source, and policy enabling/disabling status. Only the system administrator can access this system view.

Table 1 GS_ADM_ILMOBJECTS columns

Name

Type

Description

policy_name

character varying(128)

Name of an ADO policy, which is automatically generated. The name format is P + Policy ID.

object_owner

character varying(128)

Name of the schema where the data object is located.

object_name

character varying(128)

Data object name.

subobject_name

character varying(128)

Data object partition name or level-2 partition name.

object_type

character varying(18)

Data object type.

  • r: table
  • p: partition
  • s: level-2 partition

inherited_from

character varying(20)

Object whose policy is inherited by the current policy. The options are as follows:

  • TABLE: table
  • TABLE PARTITION: partition
  • POLICY NOT INHERITED: not inherited

tbs_inherited_from

character varying(30)

TS whose policy is inherited by the current policy. The value is null in the current version.

enabled

character varying(7)

Specifies whether the policy is enabled for the current object.

deleted

character varying(7)

Specifies that the ILM policy on the object is deleted. If the partition or the policy on the partition is deleted, the record (ILMOBJ) is deleted.