oracle 测试rollbakce 存储空间是否发生变化
1、执行
create table sjzhk_objects as
select * from all_objects t;
select * from user_segements;
2、
create table sjzhk_objects21 as select * from all_objects where 1=2;
select * from user_segments t ;
3、
insert into sjzhk_objects21 select * from all_objects
select * from user_segments t ;
未提交时，数据其实已经存入到存储空间中
rollback，数据得到释放吗？？？
select * from user_segments t ;
查看两张表的数据量
tom:rollback逻辑上恢复原状
