DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.CDB_ILMDATAMOVEMENTPOLICIES

Object Details
Object Name: CDB_ILMDATAMOVEMENTPOLICIES
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Data movement related policies in database in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
POLICY_NAME VARCHAR2 (128) Yes Name of the policy
ACTION_TYPE VARCHAR2 (11)
Type of the action executed by the policy
SCOPE VARCHAR2 (7)
Scope of the policy
COMPRESSION_LEVEL VARCHAR2 (30)
Compression level for the object
TIER_TABLESPACE VARCHAR2 (128)
Tablespace to move the object to in case of storage tiering policy
TIER_STATUS VARCHAR2 (9)
CONDITION_TYPE VARCHAR2 (22)
Column on which the policy is based
CONDITION_DAYS NUMBER

Value associated with the condition specified in days
CUSTOM_FUNCTION VARCHAR2 (128)
Optional function that evaluates the precondition on the policy
CON_ID NUMBER

container id
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT POLICY_NAME
,      ACTION_TYPE
,      SCOPE
,      COMPRESSION_LEVEL
,      TIER_TABLESPACE
,      TIER_STATUS
,      CONDITION_TYPE
,      CONDITION_DAYS
,      CUSTOM_FUNCTION
,      CON_ID
FROM SYS.CDB_ILMDATAMOVEMENTPOLICIES;

Dependencies

[top of page]

SYS.CDB_ILMDATAMOVEMENTPOLICIES does not reference any database object

SYS.CDB_ILMDATAMOVEMENTPOLICIES is referenced by following:

SchemaPUBLIC
SynonymCDB_ILMDATAMOVEMENTPOLICIES