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

From: Lynux <lynux_at_netvigator.com>
Date: 21 Aug 1999 20:45:55 GMT
Message-ID: <7pn363$g7h$1@imsp009a.netvigator.com>

Actually, we have already add new data files for many tablespace with our previously posted format. The syntax seems correct as we already created the data file in the file system (that actually is a symbolic link linked to a raw device with about 1Gb for each). In fact, someone have suggested me to export the data in the tablespace. Drop it and recreate the one. However, every table in the tablespace utilitizes about 2Gb to 14Gb of data records. If we have to export them, our estimation will take about 30Gb of harddisk and 10 hours for full export from the tablespace with direct path.

Dan Benwell <dan_at_benwell.co.uk> wrote:
: 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 - 15:45:55 CDT