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 <[EMAIL PROTECTED]> 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$UtgqW1WVCEbgQKjAOxhhoQ==$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]
