Re: Help for message ORA-01118.

check the limit for your operating system, check the limit you set in the create database command.

if you are at your create limit, you can alter it up to the maximum that your operating system allows.

if you are at your operating system limit, you can export a tablespace that has several datafiles, drop the tablespace and create it with one datafile that is combined size of the previous datafiles, and import the tablespace data.

Marco Vallecoccia wrote:
>
> When I attempt to create a tablespace, I receive message:
> ORA-01118 CANNOT ADD ANY MORE DATABASE FILES
>
> Message and Code manual tells me that I have to export the database e
> re-create it. Is there another solution ????.
>
> :-) Thanks in advance !!!.
  Received on Thu Oct 09 1997 - 00:00:00 CDT