Oracle .dmp 文件
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/2471845/
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
Oracle .dmp file
提问by mainstringargs
I have an oracle .dmp file, and no access to a local oracle install..
我有一个 oracle .dmp 文件，但无法访问本地 oracle 安装..
Is there any way I can read the data or open it in another program to see what data is in this file?
有什么方法可以读取数据或在另一个程序中打开它以查看此文件中的数据吗？
回答by Sathyajith Bhat
Nope, the .dmpfiles are generally meant to be read and imported by Oracle's imptool
不，这些.dmp文件通常是由 Oracle 的imp工具读取和导入的
If that's it, don't waste your time. DMP files are to be read by Oracle's IMP utility and nothing else (you could, of course, use any editor, but you're close to see nothing useful in there).
如果是这样，不要浪费你的时间。DMP 文件将由 Oracle 的 IMP 实用程序读取，没有别的（当然，您可以使用任何编辑器，但您几乎看不到那里有任何用处）。
http://www.orafaq.com/forum/t/64809/42800/
http://www.orafaq.com/forum/t/64809/42800/
Seems if you have a licensed copy of Toad, you can use the DBA utilities to view the files
似乎如果您有 Toad 的许可副本，您可以使用 DBA 实用程序查看文件
The DBA utilities in TOAD has File Browser that allows you to view export files. Although I think this function is only available in a fully licensed copy of TOAD.
TOAD 中的 DBA 实用程序具有允许您查看导出文件的文件浏览器。虽然我认为此功能仅在 TOAD 的完全许可副本中可用。
回答by DCookie
If all you want is a feel for what's in there, open it with Vi or Notepad++ or some other reasonable editor and you can see the DDL statements scattered throughout. A lot of the data will be intelligible as well. However, it IS a binary file, so making a lot of use of it is problematic. Also, if it's huge, the editor you use may not be able to handle it, so you might want to use a pager like less.
如果您只想了解其中的内容，请使用 Vi 或 Notepad++ 或其他一些合理的编辑器打开它，您可以看到散布在各处的 DDL 语句。许多数据也将是可理解的。然而，它是一个二进制文件，所以大量使用它是有问题的。此外，如果它很大，您使用的编辑器可能无法处理它，因此您可能希望使用像less这样的寻呼机。
That said, can't you download the Oracle Client software and install it? The administrator utilities in there include imp/exp IIRC.
也就是说，您不能下载 Oracle Client 软件并安装它吗？那里的管理员实用程序包括 imp/exp IIRC。
