eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: SYS.USER_ILMDATAMOVEMENTPOLICIES

Object Details

Object Name:	USER_ILMDATAMOVEMENTPOLICIES
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

Data movement related policies for a user

[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)
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

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
FROM SYS.USER_ILMDATAMOVEMENTPOLICIES;

Dependencies

[top of page]

SYS.USER_ILMDATAMOVEMENTPOLICIES references the following:

SYS: ILM$; ILMPOLICY$; TS$; TSQ$

SYS.USER_ILMDATAMOVEMENTPOLICIES is referenced by following:

PUBLIC: USER_ILMDATAMOVEMENTPOLICIES