读书人

扔掉表还能返回

发布时间: 2012-08-03 00:12:14 作者: rapoo

扔掉表,还能回来

create table aaabbb(
aa number primary key not null,
bb varchar2(255)
);
insert into aaabbb values(222,333);
select * from aaabbb;


drop table aaabbb;

select * from user_recyclebin where original_name = 'aaabbb';
FLASHBACK TABLE aaabbb to before drop;

读书人网 >其他数据库

热点推荐