Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How Do I create a Table Space over 16 GB?
Thanks guys worked fine. Just assing some .ora files to the table
space.
On Tue, 12 Mar 2002 23:50:46 GMT, damorgan <damorgan_at_exesolutions.com>
wrote:
>Are you trying to do this in a single datafiile? Add another one to the
>tablespace.
>
>Daniel Morgan
>
>
>
>Barry Raymond wrote:
>
>> I'm having problems with Oracle and a large database. I have plenty
>> of disk space but the database pukes when it gets to 16GB. When I try
>> to enlarge the datafile I get this error:
>>
>> ORA-01144:(File size (4198600 blocks) exceeds maximum of 4194303
>> blocks.
>>
>> I'm running Oracle 9i Enterprise on W2K on an NTFS filesystem. I've
>> been reading up on the Oracle Raw file system, but it really doesn't
>> metion over comming this problem and NTFS can handle really big file
>> sizes anyway. Is there a way to enably 64bit file system support
>> under W2K? The DB gets so large because I am inserting pictures into
>> it so I can't just make the DB smaller.
Received on Mon Mar 18 2002 - 09:57:15 CST
![]() |
![]() |