是否可以在虚拟机上使用Oracle 11g Express上的“impdb”？

I need to use Oracle for development purpose on my OSX machine so I downloaded an Oracle 11g Express virtualbox which runs on Linux. Further, I do want to import a database dump file which was exported by "expdb" to this environment but I found that "impdb" tool is not a part of the Oracle 11g express virtualbox.

我需要在我的OSX机器上使用Oracle进行开发,因此我下载了一个在Linux上运行的Oracle 11g Express虚拟机。此外,我确实想要导入由“expdb”导出到此环境的数据库转储文件,但我发现“impdb”工具不是Oracle 11g express虚拟机的一部分。

I have searched through many articles and documentations but it seems like "impdb" is shipped with the full installation of Oracle, not the express one (correct me if I'm wrong). Thus, I wonder if is there any way I can use "impdb" to import my database dump file to this Oracle 11g express environment?

我搜索了很多文章和文档,但似乎“impdb”随Oracle的完整安装一起提供,而不是快速安装(如果我错了,请纠正我)。因此,我想知道是否有任何方法可以使用“impdb”将我的数据库转储文件导入此Oracle 11g Express环境?

1 个解决方案

#1

Datapump is available in XE:

Datapump在XE中可用:

Note! Look for expdp and impdp

注意!寻找expdp和impdp

§ WORKSTATION1 {C:\o\a\o\p\1\s\bin} dir *dp.exe


    Directory: C:\oraclexe\app\oracle\product\11.2.0\server\bin


Mode                LastWriteTime     Length Name
----                -------------     ------ ----
-a---        27.08.2011     10:58     126976 expdp.exe
-a---        27.08.2011     10:58     131072 impdp.exe

#1