linux查看文件数据大小限制,Oracle数据库物理文件大小的限制简介

引用:

Windows NT Maximum 4GB files on FAT

Theoretical 16TB on NTFS

Sun Solaris (32 bit Oracle releases)

=======================================

OS Limits

~~~~~~~~~

Release Max file-system size Max OS File size

< Solaris 2.6 1TB (UFS) 2GB

>= Solaris 2.6 1TB (40 bits) 1TB

Oracle Limits

~~~~~~~~~

SOLARIS 2.6 / 2.7 / 2.8

File Exp/ Loader

Oracle System Raw Imp** see ** UTL_FILE

==========================================

8.1.6.0 >4GB >=2GB >=2GB >=2GB >=2GB

8.1.5.0 32Bit >4GB >=2GB <2GB <2GB <2GB

8.1.5.0 64Bit >4GB >=2GB <2GB

8.0.6.0 >4GB >=2GB <2GB >2GB

8.0.5.2 >4GB >=2GB <2GB <2GB <2GB

8.0.5.1 <4GB >=2GB <2GB <2GB <2GB

8.0.5.0 <2GB >=2GB <2GB <2GB <2GB

>=8.0.4.2 <4GB >=2GB <2GB <2GB <2GB

< 8.0.4.2 <2GB >=2GB <2GB <2GB <2GB

8.0.3.x <2GB >=2GB <2GB <2GB <2GB

7.3.4.x <2GB >=2GB <2GB <2GB <2GB

7.3.3.x <2GB >=2GB <2GB <2GB <2GB

HP

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

HPUX Unix Limits

~~~~~~~~~~~~~~~~~

Max file system size:

<= HP-UX 10.10 4GB

>= HP-UX 10.20 128GB

>= HP-UX 11.00 1TB

Max OS file size:

<= HP-UX 10.10 2GB

>= HP-UX 10.20 128GB

>= HP-UX 11.00 1TB

Oracle on HPUX Limits

~~~~~~~~~~~~~~~~~~~~~~

Max Datafile Size

File Raw Async Export/ SQL*Loader

Release System Device I/O Import** (see **)

=============================================

8.1.7.x 64GB 64GB raw only >2GB >2GB

8.1.6.x 64GB 64GB raw only >2GB >2GB

8.0.6.x 64GB 64GB raw only See*1 See*2

8.0.5.x 64GB 64GB raw only See*1 <2GB

8.0.4.x 64GB 64GB raw only SIL HPUX10.20 > 2GB

HPUX-11 <2GB

8.0.3.x <2GB <2GB raw only 2GB 2GB

7.3.4.x 64GB 64GB raw only SIL 2GB

>=7.3.3.4.1 64GB 64GB raw only SIL 2GB

7.3.2.3 <2GB <2GB raw only 2GB 2GB

7.1.6 <2GB <2GB raw only 2GB 2GB