日期:2014-05-16  浏览次数:20660 次

请问是否可以从oracle的dmp文件中直接访问和读取数据
如果知道表结构的情况下,是否可以从oracle的dmp文件中直接访问和读取数据。
论坛中有人说是加密的,
也有人说dmp文件中是insert语句的集合,但我打开看了好像不是,是否与版本或dump方式有关?
希望在这里得到一个终极答案。
谢谢。

------解决方案--------------------
dmp文件格式由Oracle公司自己制定。而且格式不公开。所以,最好不要直接访问和尝试读取里边的数据。
它应该是一个二进制文件。

如果是insert语句的集合,你应该可以用UEdt或者grep能查出来。显然不是。
------解决方案--------------------
An export file is an Oracle binary-format dump file that is typically located on disk or tape.

Export dump files can only be read by the Oracle Import utility.
------解决方案--------------------
其实,如果你了解dmp格式是可以自己写一个程序去解析,但这个需要oracle公开其格式才行。

这个是oracle官方文档中的说明
An Export file is an Oracle binary-format dump file that is typically located on disk or tape. The dump files can be transferred using FTP or physically transported (in the case of tape) to a different site. The files can then be used with the Import utility to transfer data between databases that are on systems not connected through a network. The files can also be used as backups in addition to normal backup procedures.

Export dump files can only be read by the Oracle Import utility. The version of the Import utility cannot be earlier than the version of the Export utility used to create the dump file.

------解决方案--------------------
学习了
------解决方案--------------------
探讨
引用:
An export file is an Oracle binary-format dump file that is typically located on disk or tape.

Export dump files can only be read by the Oracle Import utility.

请问一下这是官方的说明吗……

------解决方案--------------------
学习中!
------解决方案--------------------
itpub上有个这样的工具好像。