Report Manager Repository Maintenance-Archived Reports Removed?
I want to purge the Oracle Report Manager Repository of old reports. When I run the query below, there are a large number of reports that have the 'ARCHIVED_FLAG' = Y and the END_DATE in the past. So, if I run the ORM Repository Maintenance program, will these reports be completely removed from the repository to free up space? I need to understand how to automatically purge reports from the repository.
Thank you,
Nancy
Here is the query I used:
SELECT RLOB.FILE_ID,
DOC.USER_NAME "DOC_NAME",
doc2.directory_id,
RLOB.CREATION_DATE,
DBMS_LOB.GetLength("FILE_DATA")/1024 AS FILE_DATA_KB,