2Gb or Not 2Gb - File limits in Oracle (Part II)

<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 728x15, 创建于 08-4-23MSDN */google_ad_slot = "3624277373";google_ad_width = 728;google_ad_height = 15;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>

<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 160x600, 创建于 08-4-23MSDN */google_ad_slot = "4367022601";google_ad_width = 160;google_ad_height = 600;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>

ormal style="MARGin: 0cm 0cm 0pt">ormal">II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">ing: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA">2Gb or Not 2Gb - File limits in oracle (Part II)

ormal style="MARGin: 0cm 0cm 0pt">ormal">ine: wave">II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma"> 

ormal style="MARGin: 0cm 0cm 0pt">ormal">ine: wave">II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">导出（ormal">ine: wave">Exportormal">ine: wave">II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">）和ormal">ine: wave">2Gb

ormal style="MARGin: 0cm 0cm 0pt"> 

ormal style="MARGin: 0cm 0cm 0pt">2GbII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">导出文件的大小

ormal style="MARGin: 0cm 0cm 0pt">II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">当编写大部分版本的ExportII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">时，在创建导出文件上都是使用了默认的文件操作APIII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">。这就意味着在很多平台上根本就没有可能导出2GbII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">或者大于2GbII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">的文件系统文件（File system FileII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">）。

ormal style="MARGin: 0cm 0cm 0pt">II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">但是仍然有一些可选项可以用于在ExportII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">时解决2GbII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">的限制：

ormal style="MARGin: 0cm 0cm 0pt"> 

ormal style="MARGin: 0cm 0cm 0pt 21pt; TEXT-inDENT: -21pt; mso-list: l5 level1 lfo6; tab-stops: list 21.0pt">ingdings; mso-bidi-font-family: Wingdings; mso-fareast-font-family: Wingdings">ore">ü         II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">将大于2GbII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">的文件导出到裸设备上基本上是没有问题的，当然这首先要求裸设备的大小必须能够容纳整个导出文件。

ormal style="MARGin: 0cm 0cm 0pt 21pt; TEXT-inDENT: -21pt; mso-list: l5 level1 lfo6; tab-stops: list 21.0pt">ingdings; mso-bidi-font-family: Wingdings; mso-fareast-font-family: Wingdings">ore">ü         II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">导出到一个允许压缩或者切割的命名管道中（适用UnixII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">平台）。

ormal style="MARGin: 0cm 0cm 0pt; TEXT-inDENT: 21pt">II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">参看“在UnixII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">平台上导出大于2GbII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">文件的快速参考”一文 ink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_id=30528.1&p_database_id=Not" target=corner>[NotE:30528.1]II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">。

ormal style="MARGin: 0cm 0cm 0pt 21pt; TEXT-inDENT: -21pt; mso-list: l5 level1 lfo6; tab-stops: list 21.0pt">ingdings; mso-bidi-font-family: Wingdings; mso-fareast-font-family: Wingdings">ore">ü         II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">导出到磁带（适用大多数平台）

ormal style="MARGin: 0cm 0cm 0pt 21pt">II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">参看“在UnixII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">系统中导出到磁带”一文or/Editor.htm#_[NotE:30428.1]" target=corner>[NotE:30428.1]II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">。（这篇文章同时页详细描述了如何导出到UnixII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">管道和远程shellII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">中）

ormal style="MARGin: 0cm 0cm 0pt 21pt; TEXT-inDENT: -21pt; mso-list: l5 level1 lfo6; tab-stops: list 21.0pt">ingdings; mso-bidi-font-family: Wingdings; mso-fareast-font-family: Wingdings">ore">ü         oracle8iII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">允许导出到多个小文件中，以替代单一的大文件。

ormal style="MARGin: 0cm 0cm 0pt"> 

ormal style="MARGin: 0cm 0cm 0pt">II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">其它的2GbII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">导出问题

ormal style="MARGin: 0cm 0cm 0pt">oracleII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">允许区（extentII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">）的尺寸最大为2GbII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">。但是不幸的是，在大多数的oracleII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">发行版中ExportII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">都存在这样一个问题，当你ExportII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">一个大文件，并且指定了COMPRESS=YII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">，那么就有可能在导出文件的NEXTII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">存储子句中包含了一个大于2GbII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">的值。这样将会导致ImportII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">失败，即使是在ImportII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">时候指定了IGNorE=YII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">。oracleII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">已经在在or/Editor.htm#_[BUG:708790]" target=corner>[BUG:708790]II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">中报告了这个问题，并且在or/Editor.htm#_[NotE:62436.1]" target=corner>[NotE:62436.1]II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">中提出了警告。

ormal style="MARGin: 0cm 0cm 0pt"> 

ormal style="MARGin: 0cm 0cm 0pt">II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">当ExportII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">碰到2GbII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">限制的时候，会报类似下面的错误：

ormal style="MARGin: 0cm 0cm 0pt">. . exporting table                   BIGEXPorT

ormal style="MARGin: 0cm 0cm 0pt">EXP-00015: error on row 10660 of table BIGEXPorT, 

ormal style="MARGin: 0cm 0cm 0pt">       column MYCOL, datatype 96

ormal style="MARGin: 0cm 0cm 0pt">EXP-00002: error in writing to export File

ormal style="MARGin: 0cm 0cm 0pt">EXP-00002: error in writing to export File

ormal style="MARGin: 0cm 0cm 0pt">EXP-00000: Export terminated unsuccessfully

ormal style="MARGin: 0cm 0cm 0pt"> 

ormal style="MARGin: 0cm 0cm 0pt">II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">在ink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_id=185855&p_database_id=BUG" target=corner>[BUG:185855]II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">中提到了第二个问题，这个问题指出一个全库导出产生的CREATE TABLESPACEII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">命令将在文件大小上使用BYTESII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">为单位，如果文件大小超过2GbII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">，那么在导入的时候就会产生一个orA-2237II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">错误。这个问题可以通过在导入之前先以MII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">为单位而不是BYTESII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">为单位来创建表空间这样的方法来解决。ink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_id=490837&p_database_id=BUG" target=corner>[BUG:490837]II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">也指出了相类似的问题。

ormal style="MARGin: 0cm 0cm 0pt"> 

ormal style="MARGin: 0cm 0cm 0pt">II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">导出到磁带

ormal style="MARGin: 0cm 0cm 0pt">II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">导出的时候VOLSIZEII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">参数限制在4GbII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">以下，在有些平台上可能只有2GbII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">。

ormal style="MARGin: 0cm 0cm 0pt">II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">在oracle8iII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">中已经修正了这个问题。ink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_id=490190&p_database_id=BUG" target=corner>[BUG:490190]II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">中对此问题有所描述。

ormal style="MARGin: 0cm 0cm 0pt"> 

ormal style="MARGin: 0cm 0cm 0pt">ormal">ine: wave">SQL*Loaderormal">ine: wave">II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">和ormal">ine: wave">2Gb

ormal style="MARGin: 0cm 0cm 0pt">II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">在SQL*LoaderII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">试图打开一个超过2GbII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">的文件时，将会报以下错误：

ormal style="MARGin: 0cm 0cm 0pt">       SQL*Loader-500: Unable to open File (bigFile.dat)

ormal style="MARGin: 0cm 0cm 0pt">       SVR4 Error: 79: Value too large for defined data type

ormal style="MARGin: 0cm 0cm 0pt"> 

ormal style="MARGin: 0cm 0cm 0pt">II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">在ink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_id=30528.1&p_database_id=Not" target=corner>[NotE:30528.1]II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">中的例子可以稍作修改以使在SQL*LoaderII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">中使用大的输入文件。

ormal style="MARGin: 0cm 0cm 0pt">oracle 8.0.6II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">在SQL*LoaderII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">中已经对discard FileII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">和log FileII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">实现了大文件支持，但是对于输入的data FileII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">在各个平台上仍然时不一样的。ink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_id=948460&p_database_id=BUG" target=corner>[BUG:948460]II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">中记录了输入文件大小限制的详细信息。ink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_id=749600&p_database_id=BUG" target=corner>[BUG:749600]II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">则记录了最大的discard FileII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">文件大小。

ormal style="MARGin: 0cm 0cm 0pt"> 

ormal style="MARGin: 0cm 0cm 0pt">ormal">ine: wave">oracleormal">ine: wave">II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">和其它的ormal">ine: wave">2Gbormal">ine: wave">II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">问题ormal">ine: wave">

ormal style="MARGin: 0cm 0cm 0pt">II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">这个章节列举了其它各色2GbII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">问题。

ormal style="MARGin: 0cm 0cm 0pt"> 

ormal style="MARGin: 0cm 0cm 0pt 21pt; TEXT-inDENT: -21pt; mso-list: l6 level1 lfo7; tab-stops: list 21.0pt">ingdings; mso-bidi-font-family: Wingdings; mso-fareast-font-family: Wingdings">ore">l         oracle 8.0.5II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">版本以后在大部分的平台上oracleII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">都提供了64II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">位的版本。从8.0.5II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">的READMEII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">文件中可以看到相应的介绍－or/Editor.htm#_[NotE:62252.1]" target=corner>[NotE:62252.1]

ormal style="MARGin: 0cm 0cm 0pt 21pt; TEXT-inDENT: -21pt; mso-list: l6 level1 lfo7; tab-stops: list 21.0pt">ingdings; mso-bidi-font-family: Wingdings; mso-fareast-font-family: Wingdings">ore">l         DBVII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">（数据库验证程序）可能无法扫描超过2GbII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">的数据文件，并会报DBV-100II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">错误。在ink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_id=710888&p_database_id=BUG" target=corner>[BUG:710888]II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">中报告了此错误。

ormal style="MARGin: 0cm 0cm 0pt 21pt; TEXT-inDENT: -21pt; mso-list: l6 level1 lfo7; tab-stops: list 21.0pt">ingdings; mso-bidi-font-family: Wingdings; mso-fareast-font-family: Wingdings">ore">l         II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">如果要在oracleII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">中创建大于2GbII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">的文件， SQLII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">命令行的"DATAFile ... SIZE xxxxxx"II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">子句部分必须以MII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">或者KII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">作单位来指定，否则将会报"orA-02237: invalid File size"II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">错误。在ink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_id=185855&p_database_id=BUG" target=corner>[BUG:185855]II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">中报告了此错误。

ormal style="MARGin: 0cm 0cm 0pt 21pt; TEXT-inDENT: -21pt; mso-list: l6 level1 lfo7; tab-stops: list 21.0pt">ingdings; mso-bidi-font-family: Wingdings; mso-fareast-font-family: Wingdings">ore">l         II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">在oracle 7.3.4II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">发行版以前表空间的限额不能超过2GbII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">。比如：

ormal style="MARGin: 0cm 0cm 0pt; TEXT-inDENT: 21pt">ALTER USER <username> QUOTA 2500M ON <tablespacename>

ormal style="MARGin: 0cm 0cm 0pt; TEXT-inDENT: 21pt">II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">这样将会报" orA-2187: invalid quota specification."II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">错误。

ormal style="MARGin: 0cm 0cm 0pt 21pt">II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">在ink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_id=425831&p_database_id=BUG" target=corner>[BUG:425831]II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">中报告了此错误。解决方法是如果一个用户需要超过2GbII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">的限额，那么就给他赋予UNLIMITED TABLESPACEII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">权限。

ormal style="MARGin: 0cm 0cm 0pt 21pt; TEXT-inDENT: -21pt; mso-list: l6 level1 lfo7; tab-stops: list 21.0pt">ingdings; mso-bidi-font-family: Wingdings; mso-fareast-font-family: Wingdings">ore">l         II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">如果spoolII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">的输出文件达到了2GbII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">，那么会出现错误。比如：SQLPLUSII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">的命令spoolII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">。

ormal style="MARGin: 0cm 0cm 0pt 21pt; TEXT-inDENT: -21pt; mso-list: l6 level1 lfo7; tab-stops: list 21.0pt">ingdings; mso-bidi-font-family: Wingdings; mso-fareast-font-family: Wingdings">ore">l         II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">在oracleII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">工具中的一些CorEII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">函数不支持大文件。ink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_id=749600&p_database_id=BUG" target=corner>[BUG:749600]II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">中报告了此错误，在oracle 8.0.6II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">和8.1.6II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">版本中已经修正了。但是要注意在oracle 8.1.5II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">和别的任何补丁中都没有修改这个错误。另外即使已经有修正，但是仍然还会有大文件限制因为不是所有的代码都使用了这些CorEII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">函数。

ormal style="MARGin: 0cm 0cm 0pt 21pt">II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">注意：ink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_id=749600&p_database_id=BUG" target=corner>[BUG:749600]II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">虽然阐明了CorEII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">函数，但是代码的某些部分仍然有问题。比如：SQL*LoaderII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">中输入文件的读取就没有使用CorEII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">。

ormal style="MARGin: 0cm 0cm 0pt 21pt; TEXT-inDENT: -21pt; mso-list: l6 level1 lfo7; tab-stops: list 21.0pt">ingdings; mso-bidi-font-family: Wingdings; mso-fareast-font-family: Wingdings">ore">l         UTL_FileII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">包使用了上述的CorEII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">函数，所以在没有修正的oracleII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">版本中仍然有2GbII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">限制。<Package:UTL_File>II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">是一个允许在PL/SQLII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">中进行文件存取的PL/SQLII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">包。

ormal style="MARGin: 0cm 0cm 0pt"> 

ormal style="MARGin: 0cm 0cm 0pt">ormal">ine: wave">II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">特定平台中的大文件ormal">ine: wave">

ormal style="MARGin: 0cm 0cm 0pt">II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">下面是一些特定平台中关于大文件支持的参考资料。虽然我们已经努力使这些文章的资料始终保持更新，但是仍然建议在存取大文件时对每一个操作要小心谨慎地测试。

ormal style="MARGin: 0cm 0cm 0pt"> 

ormal style="MARGin: 0cm 0cm 0pt">II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">平台

ormal style="MARGin: 0cm 0cm 0pt">II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">参考

ormal style="MARGin: 0cm 0cm 0pt">AIX (RS6000 / SP)

ormal style="MARGin: 0cm 0cm 0pt">or/Editor.htm#_[NotE:60888.1]" target=corner>[NotE:60888.1]

ormal style="MARGin: 0cm 0cm 0pt">HP

ormal style="MARGin: 0cm 0cm 0pt">or/Editor.htm#_[NotE:62407.1]" target=corner>[NotE:62407.1]

ormal style="MARGin: 0cm 0cm 0pt">Digital Unix

ormal style="MARGin: 0cm 0cm 0pt">or/Editor.htm#_[NotE:62426.1]" target=corner>[NotE:62426.1]

ormal style="MARGin: 0cm 0cm 0pt">Sequent PTX

ormal style="MARGin: 0cm 0cm 0pt">or/Editor.htm#_[NotE:62415.1]" target=corner>[NotE:62415.1]

ormal style="MARGin: 0cm 0cm 0pt">Sun Solaris

ormal style="MARGin: 0cm 0cm 0pt">or/Editor.htm#_[NotE:62409.1]" target=corner>[NotE:62409.1]

ormal style="MARGin: 0cm 0cm 0pt">Windows NT

ormal style="MARGin: 0cm 0cm 0pt">FATII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">文件系统支持最大4GbII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">的文件

ormal style="MARGin: 0cm 0cm 0pt">NTFSII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">文件系统理论上支持最大16TbII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">的文件

ormal style="MARGin: 0cm 0cm 0pt">1II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">．在NTII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">的oracle8II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">上使用大文件之前请先参考or/Editor.htm#_[NotE:67421.1]" target=corner>[NotE:67421.1]

ormal style="MARGin: 0cm 0cm 0pt">2II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">．oracle8.1.6II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">的DBVERIFYII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">程序有问题（参考or/Editor.htm#_[BUG:1372172]" target=corner>[BUG:1372172]II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">）

ormal style="MARGin: 0cm 0cm 0pt">3II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">．在8.1.6 / 8.1.7II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">中自动扩展到4GbII-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">时会出现问题导致数据库崩溃。（参考or/Editor.htm#_[BUG:1668488]" target=corner>[BUG:1668488]II-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">）

<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 728x15, 创建于 08-4-23MSDN */google_ad_slot = "3624277373";google_ad_width = 728;google_ad_height = 15;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>

<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 160x600, 创建于 08-4-23MSDN */google_ad_slot = "4367022601";google_ad_width = 160;google_ad_height = 600;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>