I was doing some maintenance on oracle database object 11g, but in the middle of this adventure I ended up compiling and recompiling versions that gave an error. I would like to know if there is any way to perform a TIMESTAMP on PACKAGES database objects in Oracle 11G. Ex: I want to return the script contained in PACKAGE BODY A on 10/08/2018. I tried this solution but apparently only with the system user is it possible:
select text
from dba_source as of timestamp
TO_TIMESTAMP('10/08/2018 14:00:00', 'dd/mm/yyyy hh24:mi:ss')
where name='PACKAGE_Q_DEU_MERDA'
order by line;