不久前，我在我的开发机器上安装了 Oracle 10g XE 数据库。从那时起，我在 XE 安装之上安装了 Application Express。换句话说，它是在 10g 上运行的 APEX。我发现我其实并不需要 APEX（事实证明我是在 ASP.NET 和 Oracle 中进行开发），而且我记得在安装 APEX 之前有更多的 GUI 来管理 XE 10g 实例。
我可以在保留原来的 XE 安装的情况下删除 APEX 吗？我尝试重新安装原始的 XE，但我没有找到在不安装新 HOME 的情况下执行此操作的方法（我不想这样做；这让我感到困惑）。 TIA。
Awhile back I installed the Oracle 10g XE database on my dev machine. Since then, I installed Application Express over top of the XE installation. In other words, it's APEX running on 10g. I found I don't really need APEX after all (it's turned out I'm developing in ASP.NET and Oracle instead), and I recall having more of a GUI to manage the XE 10g instance BEFORE I installed APEX.
Can I remove APEX while leaving my original XE installation? I tried to re-install the original XE, but I didn't see a way of doing this without installing a new HOME (which I'd rather not do; it confuses me). TIA.
发布评论
评论（3）
Oracle XE 附带安装了 APEX，以及（凭记忆）基于 APEX 的 XE 管理工具。听起来您实际上所做的是升级/安装更新版本的 APEX，然后一起删除 APEX。
可能最简单的方法是使用 exp 或 expdp （数据泵）备份用户架构，卸载 XE，重新安装 XE，然后导入用户架构。这将使 XE 恢复到您想要的状态。
Oracle XE comes with APEX installed, along with a ( from memory ) APEX based XE management tool. What it sounds like you actually did was was upgrade/over install a newer version of APEX, then remove APEX all together.
Probably the easiest thing to do would be to backup your user schema's using exp or expdp ( data pump ) , uninstall XE, reinstall XE and then import your user schema's. This will get XE back to how you want it.
无论您做了什么，都有很多东西（例如 PL/SQL 嵌入式网关）。您还会在 FLOWS_020100 下得到一堆东西（我认为）。
例如，当您在 XE 上安装 Apex 3.2 时，会发生什么情况：它会创建一个新架构（FLOWS_030200 或 APEX_0400000 或其他），并将一堆同义词从 FLOWS_020100 重新指向新架构。
有时（由于 XE 中的空间限制）您会删除 FLOWS_020100 架构。如果是这样，最好的办法可能是复制数据库中所需的任何内容，卸载 XE 并重新安装。
如果您仍然使用旧架构，则可以尝试遵循“恢复'说明，就像升级失败时一样。
There's a bunch of stuff (such as the PL/SQL embedded gateway) that is there irrespective of what you did. You also get a bunch of stuff under the FLOWS_020100 (I think).
What happens when you install, for example, Apex 3.2 on XE is that it creates a new schema (FLOWS_030200 or APEX_0400000 or whatever), and repoints a bunch of synonyms from FLOWS_020100 to the new schema.
Sometimes (because of the space restrictions in XE) you drop the FLOWS_020100 schema. If so, your best bet is probably to copy out anything in the database you need, un-install XE and reinstall it.
If you still have the old schema, you can have a go at following the 'reverting' instructions as you would for a failed upgrade.
AFAIK Apex 将 Web 服务器和一些脚本安装到数据库中。不过，你管理 xe 的 gui 应该改变。您确定访问的是同一个端口吗？
另外，还有SqlDeveloper，对于oracle数据库来说是一个非常好的工具。
最后，您尝试过oracle ADF进行应用程序开发吗？
AFAIK Apex installs web server and some scripts into the database. Your gui to manage xe should change, though. Are you sure you are accessing the same port?
Also, there is SqlDeveloper, quite good tool for oracle databases.
Finally, have you tried oracle ADF for application development?