从tablespace中 删除空的datafile时报ORA-03262(二)

2015-02-25 15:02:49 · 作者: · 浏览: 73
并且,不为空。
The issue has been investigated in Bug 12735162: CANNOT DROP EMPTY DATAFILE FROM TABLESPACES WITH DUPLICATED RELATIVE FILE NO


解决方法:


该bug在12.1中被解决(fix).There is also a request to include the fix in 11.2.0.3 currently being worked. ---这句话是不是在11.2.0.3中有单独的patch 能解决这个问题?


1. 变通方法是: 从empty datafile所在的表空间中move掉所有的对象,然后 drop the tablespace including contents and datafiles.


2. 为了fix 这个问题,请检查针对的你的release是否有patch,否则,请向Oracle Support 提交一个sr? 来要求一个patch。