Allow arfina : =========== Kalau di oracle 9i kita harus melakukan incomplete recovery.., dengan menggunakan change-based ., gunakan log miner., untuk mencari informasi drop table tersebut., informasi SCN atau timestamp yang ada pada log miner akan digunakan sebagai acuan untuk melakukan INCOMPLETE RECOVERY..,
mudah2 bisa membantu., Salam., An's Sembiring., --- On Fri, 7/25/08, Arfina Niata <[EMAIL PROTECTED]> wrote: From: Arfina Niata <[EMAIL PROTECTED]> Subject: Re: [indo-oracle] Balikin drop table To: [email protected] Date: Friday, July 25, 2008, 11:15 AM kalo untuk Oracle 9 sepertinya command flasback ga dikenal, ada ide lain ga ya? Makasi sebelumnya.. .. Rgds, Arfina On Fri, Jul 25, 2008 at 6:02 PM, Chandra <master_of_mobility8 [EMAIL PROTECTED] sg> wrote: > Coba pake fitur Flash back table seprti contoh dibawah ini: > > SQL> conn scott/tiger > > SQL> select tname from tab; > > TNAME > ------------ --------- --------- > DEPT > EMP > BONUS > SALGRADE > TBTEST > > SQL> drop table emp; > > Table dropped. > > SQL> select tname from tab; > > TNAME > ------------ --------- --------- > DEPT > BONUS > SALGRADE > TBTEST > BIN$UtgqW1WVCEbgQKj AOxhhoQ== $0 > > SQL> flashback table emp to before drop; > > Flashback complete. > > SQL> commit; > > Commit complete. > > SQL> select tname from tab; > > TNAME > ------------ --------- --------- > DEPT > BONUS > SALGRADE > TBTEST > EMP > > Regrads, > > Master of Mobility > > > Arfina Niata wrote: > > > > Dear all... > > > > Mohon bantuannya, gimana caranya buat balikin table yang ke drop??? > > > > Makasi sebelumnya :) > > > > [Non-text portions of this message have been removed] > > > > > > [Non-text portions of this message have been removed] > > > [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
