Accidentally deleted a view in RSA IGL 7.0.2, how to recreate the view, any ideas?
Accidentally deleted a view in RSA IGL 7.0.2, how to recreate the view, any ideas?
If you have access to another environment, you can get the SQL from there (screenshot below)
CREATE OR REPLACE FORCE EDITIONABLE VIEW "AVUSER"."PV_DATA_ACCESS_COLLECTOR" ("NAME", "ID", "COLLECTION_COUNT", "ERROR_COUNT", "DESCRIPTION", "CREATION_DATE") AS
SELECT NAME, T_DATA_COLLECTORS.ID, COLLECTION_COUNT, ERROR_COUNT, DESCRIPTION, CREATION_DATE FROM T_DATA_COLLECTORS, T_AV_DATA_ACCESS_COLLECTORS WHERE T_DATA_COLLECTORS.ID = T_AV_DATA_ACCESS_COLLECTORS.ID AND IS_DELETED = 'FALSE' WITH READ ONLY ;
COMMENT ON TABLE "AVUSER"."PV_DATA_ACCESS_COLLECTOR" IS 'Lists all data access collectors created in ACM';
If you have access to another environment, you can get the SQL from there (screenshot below)