Re: Data file size in Oracle 8.1.7 for NT

Hi,

OraDoc states:

The maximum file size for FAT is 4
GB; for NTFS, 16 Exabytes (EB).

If your unsure, wether there are bugs and if it's only a development box, just create your tablespace with 5x 2GB-files. The extra efford are 4 rows in your CREATE TABLESPACE - statement. No big deal.

Regarding the storage of your tables, it makes no difference, as long as you don't work with some extremely big initial extends (beware of the EXPORT option COMPRESS! Set it to n).

hth

On Wed, 27 Mar 2002 14:22:15 +0100, "Randi Wølner" <randiwolner_at_hotmail.com> wrote:

>I have earlier been warned against data file sizes larger than 2 G.
>Right now I am just about to create a new database for a development
>environment. There will never be taken any backup of the database, so it is
>not necessary to take any precautions in file size regarding that matter.
>But - there will (often) be done import of a dump file, where some of the
>tables are very big - 1 - 1,5G. For all the tables to "fit in" I think it
>would be a good idea to have one large data file of 10 G instead of 5 of 2
>G. Is that safe?? I think I heard sometime that there was a bug in some
>(earlier) version of Oracle for NT that made it very risky to have data
>files larger than 2G...
>
>Any experiences, ideas?
>
>Thanks,
>Randi Wølner
>
>

regards
Marc Blum
mailto:marc_at_marcblum.de
http://www.marcblum.de Received on Wed Mar 27 2002 - 08:25:45 CST