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. > > > >> > > > >> -Denny- > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > ------------------------------------ > > > > -- > > -----------I.N.D.O - O.R.A.C.L.E--------------- > > Keluar: [EMAIL PROTECTED]<indo-oracle-unsubscribe%40yahoogroups.com> > > Website: http://indooracle.wordpress.com > > ----------------------------------------------- > > > > Bergabung dengan Indonesia Thin Client User Groups, > > Terminal Server, Citrix, New Moon Caneveral, di: > > http://indo-thin.blogspot.comYahoo! Groups Links > > > > > > > > > > -- Cheers, Yoel Susanto www.indo-oracletech.com [Non-text portions of this message have been removed]
