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

Oracle Italy support solved the problem. I needed to get rid of the parameter:

    event="10119 trace name context forever, level 1" in the init file.
In a 24x7 enviornment, you can also use:

    alter session set events='10119 trace name context off';

Bye
Domenico Viggiani

Domenico Viggiani wrote:

> I'm 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: ORA-10119: before
> commiting an add datafile command
> Could anyone suggest me how to solve this problem and add a new data
> file to the tablespace successfully?
>
> Thanks in advance
> Domenico Viggiani

--
-----------------------------------------------------------------------
Domenico Viggiani               -    Systems Administrator
Pitagora S.p.A. (Gruppo Cerved) -    Via Rossini - 87036 Rende (CS)
Phone: +39 0984 836232          -    Fax: +39 0984 836200

PGP Key available on http://www.geocities.com/viggiani/sign.txt
-----------------------------------------------------------------------