This content has been marked as final. Show 7 replies
Oracle version 184.108.40.206?
However, you could look at the previous source by querying the DBA_SOURCE view using "flashback query." However, without knowing implementation details I can only guess that this may work.
Or, if you have a version control system you could look at the previous version of the code against the current version to see what the differences are.
Oracle version is 220.127.116.11Unless this is a typo, I assume you are giving us the version of the Oracle Applications Suite in use, not the version of the Oracle database.
You may want to post this question in a forum dedicated to whatever application in the suite you are using. There is nothing in the Oracle database that has any idea what was changed unless you have enabled auditing. There may be something in the particular application you are using that has some sort of information-- the application presumably has a concept of a "Request ID"-- that's not something Oracle the database knows about.
Yes the Oracle Apps version is: 18.104.22.168. This is what I get when running the script
Withi regards to using DBA_SOURCE view using "flashback query." I've never done this before, could you point me to the right direction or give me an example?
select banner from v$version Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Prod PL/SQL Release 10.2.0.4.0 - Production CORE 10.2.0.4.0 Production TNS for Linux: Version 10.2.0.4.0 - Production NLSRTL Version 10.2.0.4.0 - Production
As far as I know it's not possible to flashback a package.
You might want to look also in the [Database -General | http://forums.oracle.com/forums/forum.jspa?forumID=61&start=0] forum for threads regarding Flashback.
I believe that question has been asked there not too long ago.
And see the official docs ofcourse: http://www.oracle.com/pls/db102/search?remark=quick_search&word=flashback&tab_id=&format=ranked
Your other options are:
Ask the developers what they've been doing to that package ;)
See if the right version is backed up.
Thanks, good to know!
"You cannot retrieve past data from a V$ view in the data dictionary. Performing a query on such a view always returns the current data. You can, however, perform queries on past data in other views of the data dictionary, such as USER_TABLES."