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

From: Thomas Kyte <tkyte_at_oracle.com>
Date: 12 Mar 2002 15:31:50 -0800
Message-ID: <a6m35601j1k@drn.newsguy.com>

In article <b51t8ukd042v5afpjlucvn1n5f6qb3jbeq_at_4ax.com>, Barry says...
>
>
>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.

You have large file support already. If you have 2k blocks -- that is an 8GB file. (2k * 4194303 /1024/1024 ~ 8gig).

You do not mention your block size -- but you are hitting the max blocks/file, not a max file size limit.

Create your tablespace with more then one file (very common, a tablespace is made up of one or more files...) or... Change your db_block_size. Create a tablespace (new 9i feature) with a bigger blocksize, now you can get more allocated space in there.

       db_block_size    Maximum data file size
       -------------    ----------------------   
            2kb                 8Gb-2kb
            4kb                16Gb-4kb
            8kb                32Gb-8kb
           16kb                64Gb-16kb
           32kb               128Gb-32kb

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 

Expert one on one Oracle, programming techniques and solutions for Oracle. http://www.amazon.com/exec/obidos/ASIN/1861004826/ Opinions are mine and do not necessarily reflect those of Oracle Corp Received on Tue Mar 12 2002 - 17:31:50 CST