0
I was doing some maintenance on object database oracle 11g, but in the middle of this adventure I ended up compiling and recompiling versions that gave error. I wonder 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 of the day 10/08/2018. I tried this solution but apparently only with the system user is 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;
If I got it right, do you want to recover the package as it was on 10/08/2018? Type restore a backup?
– David
If so, the oracle would have to be with
flashback = enabled, to see the status of the package at a given date, accessing with Sys, etc.– David
That David, I had to make some changes in her and I ended up doing something wrong and now I need to get her back to the state of before I moved, I need to go back to her script of the day 10/08/2018 14:00 for example, I edited with a shape I found on the web but gave an access error, as it is in the company database the user system is kind of restricted so I would like to do with the current user, I do not know if there is any audit table that stores the changes made in Packages so I can return one of them.
– Eduardo Rafael Moraes
Search on . But I think good has how to... Search the terms.. second can see more... I will not have access to any Oracle fds
– David