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

From: Alex Hudghton <alex_at_alenda.freeserve.co.uk>
Date: Mon, 23 Aug 1999 09:49:40 +0100
Message-ID: <7pr1vf$3ko$1@taliesin.netcom.net.uk>

Lynux wrote in message <7pn363$g7h$1_at_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.

This error is an internal one, so I gues the best action would be to ask Oracle Support. However, does it have anything to do with 'maxdatafiles' ??

Alex Received on Mon Aug 23 1999 - 03:49:40 CDT