Hallo,
der Datenbank-Dump unserer Global-Solution hat 6,8GB. Dementsprechend hoch müssten die Datenbankfiles sein. Das System läuft aber unter HP-UX.
Bei uns habe ich ein Limit von 1,9GB gesetzt (wurde mir von einem DL so empfolen). Mann kann aber für Tablespaces mehrere Datenbankfiles zuordnen, was die Gesamtkapazität dementsprechend erhöht.
Was die 2GB Grenze eines Files angeht bin ich mir nicht sicher, da der W2K
Server wahrscheinlich unter NTFS-Dateisystem läuft und da habe ich folgende Infos von Microsoft:
Size Limitations in NTFS and FAT File Systems
Each file system supports a maximum volume size, file size, and number of files per volume. Because FAT16 and FAT32 volumes are limited to 4 GB and 32 GB respectively, you must use NTFS to create volumes larger than 32 GB. If you use FAT16 or FAT32 in computers that start multiple operating systems, you must note the following size limitations:
· FAT volumes smaller than 16 MB are formatted as FAT12.
· FAT16 volumes larger than 2 GB are not accessible from computers running MS-DOS, Windows 95, Windows 98, Windows Me, and many other operating systems. This limitation occurs because these operating systems do not support cluster sizes larger than 32 KB, which results in the 2 GB limit.
· In theory, FAT32 volumes can be about 8 terabytes; however, the maximum FAT32 volume size that Windows XP Professional can format is 32 GB. Therefore, you must use NTFS to format volumes larger than 32 GB. However, Windows XP Professional can read and write to larger FAT32 volumes formatted by other operating systems.
· If you create multidisk volumes such as spanned or striped volumes, the amount of space used on each disk is applied to the total size of the volume. Therefore, to create a multidisk volume that is larger than 32 GB, you must use NTFS.
For more information about FAT16 and FAT32, see "FAT File System" later in this chapter.
Maximum Sizes on NTFS Volumes
In theory, the maximum NTFS volume size is 264 clusters minus 1 cluster. However, the maximum NTFS volume size as implemented in Windows XP Professional is 232 clusters minus 1 cluster. For example, using 64-KB clusters, the maximum NTFS volume size is 256 terabytes minus 64 KB. Using the default cluster size of 4 KB, the maximum NTFS volume size is 16 terabytes minus 4 KB.
Because partition tables on master boot record (MBR) disks only support partition sizes up to 2 terabytes, you must use dynamic volumes to create NTFS volumes over 2 terabytes. Windows XP Professional manages dynamic volumes in a special database instead of in the partition table, so dynamic volumes are not subject to the 2-terabyte physical limit imposed by the partition table. Therefore, dynamic NTFS volumes can be as large as the maximum volume size supported by NTFS. Itanium-based computers that use GUID partition table (GPT) disks also support NTFS volumes larger than 2 terabytes.
Note
· If you use large numbers of files in an NTFS folder (300,000 or more), disable short-file name generation, especially if the first six characters of the long file names are similar. For more information, see "Optimizing NTFS Performance" later in this chapter.
Table 13.5 lists NTFS size limits.
Table 13.5 NTFS Size Limits
Description
Limit
Maximum file size
Theory: 16 exabytes minus 1 KB (264 bytes minus 1 KB)
Implementation: 16 terabytes minus 64 KB (244 bytes minus 64 KB)
Maximum volume size
Theory: 264 clusters minus 1 cluster
Implementation: 256 terabytes minus 64 KB ( 232 clusters minus 1 cluster)
Files per volume
4,294,967,295 (232 minus 1 file)
Maximum Sizes on FAT32 Volumes
A FAT32 volume must have a minimum of 65,527 clusters. Windows XP Professional can format FAT32 volumes up to 32 GB, but it can mount larger FAT32 volumes created by other operating systems. Table 13.6 lists FAT32 size limits.
Table 13.6 FAT32 Size Limits
Description
Limit
Maximum file size
4 GB minus 1 byte (232 bytes minus 1 byte)
Maximum volume size
32 GB (implementation)
Files per volume
4,177,920
Maximum number of files and subfolders within a single folder
65,534 (The use of long file names can significantly reduce the number of available files and subfolders within a folder.)
Maximum Sizes on FAT16 Volumes
FAT16 supports a maximum of 65,524 clusters per volume. Table 13.7 lists FAT16 size limits.
Table 13.7 FAT16 Size Limits
Description
Limit
Maximum file size
4 GB minus 1 byte (232 bytes minus 1 byte)
Maximum volume size
4 GB
Files per volume
Approximately 65,536 (216 files)
Maximum number of files and folders within the root folder
512 (Long file names can reduce the number of available files and folders in the root folder.)
Gruss
Jens
------------------
best regards
Jens Schmidt
Eine Antwort auf diesen Beitrag verfassen (mit Zitat/Zitat des Beitrags) IP
Foren auf CAD.de
| 
