oracle 使用 SQLDeveloper 3.0.04 导入和导出数据加模式
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/8894011/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Import and Export Data plus schema using SQLDeveloper 3.0.04
提问by Rehman
i am newbie to oracle and i like to export database from remote database and import it on local machine. eOn both machines i have oracle 10.2.
我是 oracle 的新手，我喜欢从远程数据库导出数据库并将其导入本地机器。e在两台机器上我都有oracle 10.2。
I need to know how to export/import schema and data from oracle 10.2 using SQLDeveloper 3.0.0.4.
我需要知道如何使用 SQLDeveloper 3.0.0.4 从 oracle 10.2 导出/导入模式和数据。
To export from remote database, i have used export Tool-> Database Export -> export wizard. and at the end i have got only sql file with DDL and DML statements but somewhere in file it is written
要从远程数据库导出，我使用了导出工具-> 数据库导出-> 导出向导。最后我只有带有 DDL 和 DML 语句的 sql 文件，但它写在文件中的某处
"Cannot render Table DDL for object XXX.TABLE_NAME with DBMS_METADATA attempting internal generator error.
I have ignored previously mentioned message and tried to run those DDL and DML statements but all this ended up with errors.
我忽略了前面提到的消息并尝试运行那些 DDL 和 DML 语句，但这一切都以错误告终。
Is it possible that all this tied with read-only database user? More over, i dont find any table under tables but also tables under other users in SqlDeveloper.
这一切是否可能与只读数据库用户有关？此外，我在 SqlDeveloper 中的其他用户下的表和表下都没有找到任何表。
Thanks in advance
提前致谢
回答by thatjeffsmith
As a test, can you select one object in the tree, and navigate to the script panel? SQLDEV also uses DBMS_METADATA to generate those scripts.
作为测试，您能否在树中选择一个对象，然后导航到脚本面板？SQLDEV 还使用 DBMS_METADATA 来生成这些脚本。
Also, as a work-around, try using DataPump to export and import your data. It will be much more efficient for moving around larger schemas.
此外，作为一种变通方法，请尝试使用 DataPump 导出和导入您的数据。移动更大的模式会更有效率。
Your note about not seeing tables under indicates your schema doesn't actually own any tables. You may be working with synonyms that allow you to query objects as if they are in your account. You could be running into a privilege issue, but your error message doesn't indicate that. Error messages often come in bunches, and the very first one is usually the most important.
您关于看不到表的注释表明您的架构实际上不拥有任何表。您可能正在使用允许您查询对象的同义词，就像它们在您的帐户中一样。您可能会遇到权限问题，但您的错误消息并未表明这一点。错误消息通常成束出现，第一个通常是最重要的。
If you could try using the EXPORT feature say against a very simple schema like SCOTT as a test, this should indicate whether there is a problem with your account settings or with the software.
如果您可以尝试使用 EXPORT 功能对 SCOTT 等非常简单的模式进行测试，这应该表明您的帐户设置或软件是否存在问题。
回答by PhatHV
I'm not sure with SQL Developer 3.0 but with version 3.1 you can follow this:
我不确定 SQL Developer 3.0 但对于 3.1 版，您可以按照以下步骤操作：
