ORA-10119: before commiting an add datafile command

From: Lynux <lynux_at_netvigator.com>
Date: 21 Aug 1999 15:24:58 GMT
Message-ID: <7pmgca$thv$1@imsp009a.netvigator.com>

We are trying to increase the size of a tablespace by adding a new data file. However, when we type and execute the following command, an ORA-10119 error occurred and stop the process.

SQL > alter tablespace test add datafile 2 '/oracle/8.0.4/dbs/dat123.dbf'
alter tablespace test add datafile
*
ERROR at line 1:
ORA-10119: before commiting an add datafile command

Is there anyone who also suffer from this problem and Could anyone suggest us how to solve this problem and add a new data file to the tablespace successfully?

Since we are using raw device for data file storage, there is no way for increase the tablespace size except adding datafiles. Moreover, up to now, the database seems running smoothly without any other problems.

Thanks in Advance! Received on Sat Aug 21 1999 - 10:24:58 CDT