免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
12
最近访问板块 发新帖
楼主: zhoulm
打印 上一主题 下一主题

Oracle数据库导出遇到2G文件大小限制!急!!!! [复制链接]

论坛徽章:
0
11 [报告]
发表于 2003-09-04 10:59 |只看该作者

Oracle数据库导出遇到2G文件大小限制!急!!!!

FILE
Default: expdat.dmp

Specifies the names of the export files. The default extension is .dmp, but you can specify any extension. Since Export supports multiple export files (see the parameter FILESIZE), you can specify multiple filenames to be used.

When Export reaches the value you have specified for the maximum FILESIZE, Export stops writing to the current file, opens another export file with the next name specified by the parameter FILE and continues until complete or the maximum value of FILESIZE is again reached. If you do not specify sufficient export filenames to complete the export, Export will prompt you to provide additional filenames.

FILESIZE
Export supports writing to multiple export files and Import can read from multiple export files. If you specify a value (byte limit) for the FILESIZE parameter, Export will write only the number of bytes you specify to each dump file.

When the amount of data Export must write exceeds the maximum value you specified for FILESIZE, it will get the name of the next export file from the FILE parameter (see FILE for more information) or, if it has used all the names specified in the FILE parameter, it will prompt you to provide a new export filename. If you do not specify a value for FILESIZE (note that a value of 0 is equivalent to not specifying FILESIZE), then Export will write to only one file, regardless of the number of files specified in the FILE parameter.

Note: If your export file(s) requirements exceed the available diskspace, Export will abort and you will have to repeat the Export after making sufficient diskspace available.

The FILESIZE parameter has a maximum value equal to the maximum value that can be stored in 64 bits.

Note: The maximum value that can be stored in a file is operating system dependent. You should verify this maximum value in your operating-system specific documentation before specifying FILESIZE. You should also ensure that the file size you specify for Export is supported on the system on which Import will run.

The FILESIZE value can also be specified as a number followed by K (number of kilobytes). For example, FILESIZE=2K is the same as FILESIZE=2048. Similarly, M specifies megabytes (1024 * 1024) while G specifies gigabytes (1024**3). B remains the shorthand for bytes; the number is not multiplied to get the final file size (FILESIZE=2048b is the same as FILESIZE=204

论坛徽章:
0
12 [报告]
发表于 2003-09-04 11:06 |只看该作者

Oracle数据库导出遇到2G文件大小限制!急!!!!

这中问题我在AIX里面做INFORMIX DUMP的时候也碰到过,没办法,也只有通过脚本方式DUMP成多个文件。

论坛徽章:
0
13 [报告]
发表于 2003-09-08 11:33 |只看该作者

Oracle数据库导出遇到2G文件大小限制!急!!!!

[quote]原帖由 "zhoulm"]我很想再长二十斤!![/quote 发表:
     
我也很想再长二十斤,哥们你有什么好方法没有?

论坛徽章:
0
14 [报告]
发表于 2003-09-08 14:23 |只看该作者

Oracle数据库导出遇到2G文件大小限制!急!!!!

[quote]原帖由 "tsgm"]在WINDOWS系统下没有这个问题。[/quote 发表:
     

那是,在windows里面文件限制是4G
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP