Re: ORA-10119: before commiting an add datafile command

You have missed off the size of the datafile

'.......dat123.dbf' size 100M;

Lynux <lynux_at_netvigator.com> wrote in message news:7pmgca$thv$1_at_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:30:57 CDT