Drop / Recreate Table / Is a redo or back out possible?

[saw15]

Using a development environment, a co-worker dropped and recreated a table without first checking what grants were allocated on that table etc. Our dba has left for vacation (2weeks), and several custom application no longer work (two of the apps used this table in production).

Can anyone tell me where the redo log / buffer would be to back out the drop? Is this possible? Is this the right step? I know the approx time /date this happened if that helped (12/6/01 0900).

Any help is greatly appreciated..very serious issue at the moment.

Thanks

 

[rcurva]

If your problems are grants only, I suggest that you grant privileges on the object instead of recovering the database, which is more tedious.



Robbie

"The rule is, not to besiege walled cities if it can possibly be avoided" -- Art of War

 

[alexhu]

I would agree with rcurva - recovery would be the wrong move - I would tend to go overboard on grants to that table and get the app working - you DBA can fix it when he gets back - you'll probably owe him a few beers though

Alex

 

[lfoata]

If you have an export of the database, You could import the table back without the rows and then look at the grants on the object, or if the data is static import the rows also. Too bad I.T. is not cash business

Luc Foata
Unix sysadmin, Oracle DBA