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

In article <38EA2877.E66CFF3C_at_hotmail.com>,   Domenico Viggiani <viggiani_at_hotmail.com> 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
>
>

Is it possible you have set event 10119 in your init.ora (to work around an issue with GROUP BY NOSORT that is fixed in 8.0.4)? If so you can either:

If in a 24 X 7 environment, you can use the following to add the datafile:

ALTER SESSION SET EVENTS='10119 trace name context off';

This will allow you to disable the event for the current session, allowing you to add the datafile. This will have to be performed at the session level eachtime a datafile needs to be added.

OR

comment out the event in your init.ora and restart the instance. If you are at 8.0.4 and above, leave it commented out - else put it back in.

--
Thomas Kyte                              tkyte_at_us.oracle.com
Oracle Service Industries
http://osi.oracle.com/~tkyte/index.html
--
Opinions are mine and do not necessarily reflect those of Oracle Corp


Sent via Deja.com http://www.deja.com/
Before you buy.