How to restore lost objects after DROP USER?

We have 817 EE on NT and one developer created a lot of procedures, functions and views. DB was not backuped and archived and export has not been done - our fault and we understand it. Sorry for this.

Ok, now the story: another developer dropped this DB user and we lost everything: procedures, functions and views. The new database user with the same name was created and new schema was imported in this user, but all old objects are lost. We don't have export and backup and archive log files.

The switch has occurred after user was dropped, the data has been overwritten and so I guess there is no way to use redo log files.

Question: may we can restore this lost stuff from some other sources. We are looking for lost codes, not data. May be we can use the Shared Pool or any other things? Any idea will be appreciated.

Is it possible to use Shared Pool or any Data Dictionary internal information to restore texts of the lost SQL and PL/SQL scripts executed in this DB before user was dropped? Not too many scripts are executed in this DB and the lost ones may still be in stack. I remember that Shared Pool (cash) should keep last executed scripts in order to improve performance. They probably are kept in some special format. Can we restore these scripts? Of course they also might be pushed out by Import that had been done after user was dropped.

Thanks for your help,

Victor
slootsky_at_erols.com Received on Mon Oct 14 2002 - 03:04:26 CEST