Magnus Olofsson wrote:

> Hello
>
> I'm about to move a 8.1.7 database from W2k to SLES8(x86). Many tables have initial extents over 2GB. Which filesystem can handle large files over 2GB?
>
> /Magnus
>
> ###########################################
> This message has been scanned by F-Secure Anti-Virus for Internet Mail.
> For more information, connect to http://www.F-Secure.com/
>

Hi Magnus,

SLES8 with ReiserFS supports large (> 2GB) files.

You should note that large files on 32-bit systems may cause problems.
I gernerally use file with 2048MB in size.

If you?ve got problems with large initial extents you have two
options:

1. Create the Tables manually before importing the tables
(i.e change the initial and next extent to a value lower than 2 GB)

2. Use Oracle 9i DB with automatic extend management


--



Mit freundlichen Gr��?en

Ronny Egner

SIV.AG
Konrad-Zuse-Stra?e 1
18184 Roggentin

Telefon: +49 (0)3 81 / 25 24 422
Telefax: +49 (0)3 81 / 25 24 399

mailto:ronny.egner@(protected)
http://www.siv.de



**********************************************************************
This email and any files transmitted with it are confidential
and intended solely for the use of the individual or entity
to whom they are addressed. The views expressed in this
e-mail are those of the individual author and not necessarily
those of SIV.AG.

This footnote also confirms that this email message has
been swept by serval anti-virus tools for the presence
of computer viruses.
**********************************************************************