如何使用SQL Developer导出大量数据-Oracle [英] How to export large amount of data using sql developer - Oracle
问题描述
我想将一些数据从UAT DB上传到DEV DB.当我尝试从SQL Developer中的Export函数执行此操作时，出现错误File C:\Users\xxx\export.sql was not opened because it exceeds the maximum automatic open size
I want to upload some data from UAT DB to DEV DB. When I try to do this from Export function in SQL Developer, I got an error File C:\Users\xxx\export.sql was not opened because it exceeds the maximum automatic open size
如何将UAT数据复制到DEV?
How can I copy the UAT data to DEV ?
ORACLE Version 12C
SQL Developer Version 4.0.0.13
推荐答案
从SQL Developer论坛中找到以下答案:
found the below answer from a SQL Developer forum :
似乎最大自动打开尺寸"被硬编码为500000(字节，我相信)的值，无法覆盖它.经过 限制了这一点，我们将Java的任何潜在抱怨抑制在萌芽状态 尝试打开大文件时出现OutOfMemory.
It appears that the "maximum automatic open size" is hard-coded to a value of 500000 (bytes, I believe) with no way to override it. By limiting this, we nip in the bud any potential complaints of Java OutOfMemory upon trying to open a huge file.
要在不受此限制的情况下从SQL Developer中查看文件， 只需使用File | Open菜单.对于那些大文件，请使用 外部编辑器.而且，如果您不想在以下位置自动打开文件 为了禁止显示警告对话框，请使用 工具|首选项|数据库|导出/查看DDL选项，然后取消选中 导出时打开Sql文件"框.
To view the file from within SQL Developer despite this limitation, just use the File|Open menu. For those huge files, please use an external editor. And if you don't want to open files automatically in order to suppress the warning dialog, use Tools|Preferences|Database|Export/View DDL Options and un-check the "Open Sql File When Exported" box.
您确定导出文件不包含所有插入行吗? 除非您遇到内存不足或磁盘已满的情况，否则这将是一个错误. 健康)状况.我刚刚在55000行表上尝试了您的方案 产生了约20MB的export.sql.所有行都包括在内.
Are you certain the export file does not contain all the insert rows? That would be a bug unless you hit an OutOfMemory or disk full condition. I just tried your scenario on at 55000 row table that produced an export.sql of about 20MB. All rows were included.
关于， 加里·格雷厄姆(Gary Graham) SQL开发人员团队
Regards, Gary Graham SQL Developer Team
作为总结，它建议SQL开发人员不是打开大型数据文件的最佳工具.
and as the summary, it suggested that the SQL developer is not the best tool to open a large size of data file.
希望加里的答案会在一定程度上指导您.
hope Gary's answer will guide you to some extent.
If you need to get an idea of some tools that you can open large files, check this LINK
这篇关于如何使用SQL Developer导出大量数据-Oracle的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
