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]

Kirim email ke