great info pak yoel. Saya akan berpikir dua kali sebelum men truncate table :).
2008/8/19 Yoel Susanto <[EMAIL PROTECTED]>: > Hi all, > > Table yang sudah di truncate datanya tidak akan bisa di recover dengan > flashback, karena undo datanya tidak ada. > kalo menggunakan DELETE statement itu masih bisa gunakan flashback.. > > Satu-satunya caranya yah restore dari backup. > > HTH, > > > 2008/8/19 m Ilhami <[EMAIL PROTECTED]> > >> >> http://luhartma.blogspot.com/2006/01/flashback-any-error-with-oracle-10g_23.html >> >> kalau masalah anda bisa terpecahkan, mohon sharing disini ya. >> >> >> On Fri, Aug 15, 2008 at 10:21 AM, Denny Kusumah <[EMAIL >> PROTECTED]<zuna_doank%40yahoo.com>> >> wrote: >> > Oracle DB 10g >> > >> > --- On Thu, 8/14/08, ronald speirs <[EMAIL >> > PROTECTED]<ronald.speirs%40gmail.com>> >> wrote: >> > From: ronald speirs <[EMAIL PROTECTED] <ronald.speirs%40gmail.com> >> > >> > Subject: Re: [indo-oracle] Rollback data table >> > To: [email protected] <indo-oracle%40yahoogroups.com> >> > Date: Thursday, August 14, 2008, 8:06 PM >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > versi database? >> > >> > >> > >> > 2008/8/15 Denny Kusumah <[EMAIL PROTECTED] com>: >> > >> >> Dear all master oracle, >> > >> >> >> > >> >> Mo tanya neh, adakah yg tau cara rollback DB >> > >> >> jika suatu tabel sudah di truncate. Jadi misalkan >> > >> >> saya men-truncate suatu tabel dengan script >> > >> >> "truncate table [nama tabel] drop storage;" kemudian >> > >> >> saya ingin mengembalikan data tabel tersebut. >> > >> >> >> > >> >> Mohon pencerahannya. >> >
