oracle PL/SQL 开发人员导入转储
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/6160097/
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
PL/SQL developer import dump
提问by Mikayil Abdullayev
I have a dump file which includes two tables. Now I need to import this dump file. I was instructed to create two tablespaces beforehands.Now how do I import this dump file to these tablespaces. I'm using PL/SQL developer.
我有一个包含两个表的转储文件。现在我需要导入这个转储文件。我被指示预先创建两个表空间。现在我如何将此转储文件导入这些表空间。我正在使用 PL/SQL 开发人员。
采纳答案by Codo
You cannot import a dump file from PL/SQL developer. Instead, you have to do it from the command line. Furthermore, you need access to the file system of the database server since you have to put the dump file in a directory directly accessible by Oracle.
您不能从 PL/SQL 开发人员导入转储文件。相反，您必须从命令行执行此操作。此外，您需要访问数据库服务器的文件系统，因为您必须将转储文件放在 Oracle 可直接访问的目录中。
The tool to import the dump file is called impdp(in earlier version, it was imp).
导入转储文件的工具称为impdp（在早期版本中为imp）。
My experience is that you need information how the dump file was created so you can use the correct import mode:
我的经验是您需要有关如何创建转储文件的信息，以便您可以使用正确的导入模式：
- Is it a dump of the full database or just a single user/schema?
- Does it include the table schema or just the table data?
- What's the schema/user name if a single schema was exported?
- etc.
- 它是完整数据库的转储还是只是单个用户/模式？
- 它包括表模式还是仅包括表数据？
- 如果导出单个架构，架构/用户名是什么？
- 等等。
You'll find more information about impdpon this PSOUG web page.
您可以在此PSOUG 网页 上找到有关impdp 的更多信息。
回答by Arthur Rocha
You CAN import a dump file from PL/SQL developer. Tools -> Import Tables... -> (at the botton of the popup screen) select the file and click in "Import".
您可以从 PL/SQL 开发人员导入转储文件。工具 -> 导入表... ->（在弹出屏幕的底部）选择文件并单击“导入”。
