CREATE OR REPLACE TYPE user_restore_point_row AS OBJECT (

  SCN                          NUMBER,

  DATABASE_INCARNATION#        NUMBER,

  GUARANTEE_FLASHBACK_DATABASE VARCHAR2(3),

  STORAGE_SIZE                 NUMBER,

  TIME                         TIMESTAMP(9),

  RESTORE_POINT_TIME           TIMESTAMP(9),

  PRESERVED                    VARCHAR2(3),

  NAME                         VARCHAR2(128),

  CLEAN_PDB_RESTORE_POINT      VARCHAR2(3),

  PDB_INCARNATION#             NUMBER,

  REPLICATED                   VARCHAR2(3),

  CON_ID                       NUMBER 

);

/

CREATE OR REPLACE TYPE user_restore_point_tab IS TABLE OF user_restore_point_row;

/

 

CREATE OR REPLACE FUNCTION user_get_restore_point return user_restore_point_tab pipelined as

begin

  for i in (select * from v_$restore_point)

loop

   pipe row (user_restore_point_row(i.SCN,i.DATABASE_INCARNATION#,i.GUARANTEE_FLASHBACK_DATABASE,i.STORAGE_SIZE,i.TIME,i.RESTORE_POINT_TIME,i.PRESERVED,[i.NAME|http://i.NAME],i.CLEAN_PDB_RESTORE_POINT,i.PDB_INCARNATION#,i.REPLICATED,i.CON_ID));

  end loop;

return;

end;

/

 

GRANT EXECUTE ON user_get_restore_point to zabbix_mon;

GRANT CREATE VIEW TO zabbix_mon;

REVOKE SELECT_CATALOG_ROLE FROM zabbix_mon;

select * from table(SYS.user_get_restore_point);

CREATE OR REPLACE VIEW zabbix_mon.v$restore_point as select * from table(SYS.user_get_restore_point);

select * from v$restore_point;