Re: How to restore views and procedures after drop user command?

Furthermore, the only thing the archived redo logs will tell you is that object XX was dropped. It won't include that object's code (if applicable).

HTH,
Brian

Mark D Powell wrote:
>
> SLootsky_at_erols.com (Victor Slootsky) wrote in message news:<8fc7e62.0210131455.4d04088e_at_posting.google.com>...
> > 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 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.
> >
> > 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 redo logs
> > or Shared Pool or any other things. Any idea will be appreciated.
> >
> > The switch has occurred after user was dropped, the data has been
> > overwritten and there is be no way to use redo log files.
> >
> > I would like to explore another opportunity. Is 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
>
> When you droped the user you also dropped the user's objects so their
> definitions are no longer stored in the dictionary. Any user owned
> object related code in the shared pool would have been invalidated and
> the space held made available for flushing. I would say you are out
> of luck and need to start recodeing.
>
> IMHO -- Mark D Powell --
Received on Tue Oct 15 2002 - 10:18:32 CDT