Thanks Joseph, I set it online, but that didn't fix the problem, I didn't tryied recover datafile I supposed when the database is restarted, the transaction needing recover was going to retry and fix by himself. -- //www.freelists.org/webpage/oracle-l