AFAIK, Flashback table baru diimplementasikan di Oracle 10g, sedangkan Oracle 8 itu belum ada. Solusi satu-satunya yaitu restore table-nya dari backup file.
CMIIW, Regards, IH --- On Fri, 7/10/09, Julius Dimas Trisaktyo Nugroho <[email protected]> wrote: From: Julius Dimas Trisaktyo Nugroho <[email protected]> Subject: Re: [indo-oracle] Help me please... munculin table yg ngilang... To: [email protected] Date: Friday, July 10, 2009, 5:31 AM boss... coba cek dulu disini: SQL> select * from user_recyclebin; kalo masih ada, berarti masih bisa direstore. kalo udah, jalankan perintah ini: SQL> FLASHBACK TABLE TB TO BEFORE DROP; balik lagi deh tuh tablenya yg ilang... selamat mencoba.. --- On Fri, 10/7/09, erry pambudhi <[email protected]. id> wrote: From: erry pambudhi <[email protected]. id> Subject: Re: [indo-oracle] Help me please... munculin table yg ngilang... To: indo-oracle@ yahoogroups. com Date: Friday, 10 July, 2009, 7:42 AM di restore aja pak... ada kan file backupnya??? -----Original Message----- From: herman sage <herman_surat@ yahoo.com> To: indo-oracle@ yahoogroups. com Date: Wed, 8 Jul 2009 05:23:18 -0700 (PDT) Subject: [indo-oracle] Help me please... munculin table yg ngilang... Dear all,.. please help me.. gimana caranya mengembalikan table yg ngilang di oracle 8.0 ? ada ga seh undrop di oracle 8.0 ? ada ga seh recylebin di oracle 8.0 ? aku mohon bantuannya.. thx, Herman [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]
