oracle大文件存储,Oracle大文件bigfile可以空间回收吗?

可以resize。

SQL> create bigfile tablespace test2 datafile ‘/data/app/oracle/oradata/killdb/test_big.dbf’ size 200m;

Tablespace created.

SQL> create table test111 tablespace test2 as select * from dba_objects;

Table created.

SQL> col name for a65

SQL> select file#,name from v$datafile;

FILE# NAME

1 /data/app/oracle/oradata/killdb/system01.dbf

2 /data/app/oracle/oradata/killdb/sysaux01.dbf

3 /data/app/oracle/oradata/killdb/undotbs01.dbf

4 /data/app/oracle/oradata/killdb/users01.dbf

5 /data/app/oracle/oradata/killdb/test.dbf

6 /data/app/oracle/oradata/killdb/test_big.dbf

7 /data/app/oracle/oradata/killdb/test3.dbf

7 rows selected.

SQL> alter database datafile 6 resize 100m;

Database altered.