下面我将做一这一实验来证明 oracle 10g r2 system@ORCL> create tablespace anbob datafile ‘/u01/app/oracle/oradata/ORCL/datafile/anbob.dbf’ size 40m; Tablespace created. anbob@ORCL> create table testspace as select * from all_objects; Table created. anbob@ORCL> select segment_name,tablespace_name from user_segments where segment_name=’TESTSPACE’; SEGMENT_NAME TABLESPACE_NAME ——————– ——————– TESTSPACE TT anbob@ORCL> select count(*) from testspace; COUNT(*) ———- 40770 anbob@ORCL> insert into testspace select * from testspace; 40770 … Continue reading truncate table 会不会释放datafile的空间？如何才能释放?