On ORACLE 7.3 and earlier versions you are restricted to 2 gigabytes for a
datafile.
yan zheng wrote in message <348B0615.AC45A0F6_at_writeme.com>...
>Beth Beckman wrote:
>
>> I have installed Oracle8 on a Windows NT machine. I got an export file
>> from another company that I'm trying to import locally. Many of the
>> tables imported, but then I ran into a space problem. So, I tried to
>> increase the space with the
>> following:
>>
>> alter tablespace
>> user_data
>> add datafile
>> 'e:\orant\database\usr2orcl.ora'
>> autoextend on next 10240 maxsize
>> 3000000000;
>>
>> I got the ORA-01119 error message that says 'error in creating
>> database
>> file 'e:\orant\database\usr2orcl.ora' because of 'insufficient space
>> on
>> device'. When I check the e: device, it has more than 2.5 GB of
>> space.
>> I also tried a maxsize of 1000 and got the same error. I'm not using
>> raw partitions. Can someone tell me what's happening?
>>
>> Thanks,
>> Beth
>
> If the data file does not exist, you have to specify a initial size.
>
Received on Tue Dec 09 1997 - 00:00:00 CST
