Re: recover from TRUNCATE TABLE via physical standby?
Date: Fri, 24 Aug 2012 08:44:49 -0500
That would certainly be ideal. Unfortunately the database in question has been something of a free-for-all since long before I was involved... we're taking steps to improve this situation, but it's going to take awhile to fully implement them. In the meantime, however, there are a lot of privileged users and the DBAs aren't always fully engaged in the app-side implementation process.
Basically I'm trying to ensure that we can deal with the occasional "oops", while at the same time working toward making the environment more supportable and stable.
On Fri, Aug 24, 2012 at 1:01 AM, Niall Litchfield < niall.litchfield_at_gmail.com> wrote:
> I see nothing wrong with the original proposal, I'd sort of hope that
> truncate was subject to change control (and code that might dynamically run
> it was peer reviewed before implementation) though.