I have written an Oracle stored procedure in a package and had my colleague ovewritten my work accidentally - he was opening a session on the same database and same package -, we are using TOAD for oracle for development, any body knows how we can recover my version of that package? Please note that we don't have any source control associated with our database, can we find a solution thru the data dictionary or something like this? Any help will be appreciated.
Unless you perform regular backup or save scripts in the file system, I'm afraid your code is lost until you rewrite it again. Good news is that you're supposed to do it faster now as you already have some experience regarding the problem procedure deals with.
However, there's still hope that someone else will know a better solution.
It is so funny I am replying to my self. I had to rewrite the procedure thanx for all reply guys. I agree with you moderator, I have to use version control from now on, any body knows a brilliant version control for Oracle9i with TOAD?
TOAD comes with the ability to plug-in to a couple of different version control products. Talk to quest.com about it (look in the menu under Team Coding).
We take a nightly export of our database (we're lucky it's small enough), and so we pull old versions of PL/SQL from there. It's not as accurate as Version Control software, but it works (plus we have a standard approach where we save the immediately prior version on our LAN when we modify).