Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How Do I create a Table Space over 16 GB?

Re: How Do I create a Table Space over 16 GB?

From: Barry Raymond <barry_at_netbotz.com>
Date: Mon, 18 Mar 2002 09:57:15 -0600
Message-ID: <fh3c9ugvdbggviroqvtiv7ef5h8u44muvs@4ax.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US