今天在群里面听到一位网友在说使用了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