使用alter database datafile 'XXX' offline drop 是否能够恢复(非归档模式下)

今天在群里面听到一位网友在说使用了alter database datafile 'XXX' offline drop命令是否能够恢复数据，在非归档模式下，下面是用一个实验来验证一下

SQL> create tablespace test datafile '/u01/app/oracle/oradata/orcl/test01.dbf' size 10M autoextend on next 1M;

Tablespace created.

SQL> create table test(id number,name varchar2(12)) tablespace test;                                               

Table created.

SQL> insert into test values (1,'colin');

1 row created.

SQL> insert into test values (2,'janey');

1 row created.

SQL> insert into test values (3,'tom');

1 row created.

SQL> insert into test values (4,'adele');

1 row created.

SQL> commit;

Commit complete.

SQL> select * from test;

        ID NAME
---------- ------------
         1 colin
         2 janey
         3 tom
         4 ade