DBA Data[Home] [Help]

VIEW: SYS.GV_$POLICY_HISTORY

Source

View Text - Preformatted

select "INST_ID","POLICY_EVENT","DATABASE_ID","TABLESPACE_ID","DATA_OBJECT_ID","TARGET_INSTANCE_NUMBER","EVENT_DATE","CON_ID" from gv$policy_history
View Text - HTML Formatted

SELECT "INST_ID"
, "POLICY_EVENT"
, "DATABASE_ID"
, "TABLESPACE_ID"
, "DATA_OBJECT_ID"
, "TARGET_INSTANCE_NUMBER"
, "EVENT_DATE"
, "CON_ID"
FROM GV$POLICY_HISTORY