oracle 如何将系统包安装到oracle？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/318665/
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
How to install system packages into oracle?
提问by George Mauer
I am creating a copy of our testing Oracle DB (10g both) and run into a problem in that our testing database has UTL_SMTP and UTL_FILE system packages installed and my local OracleXE version does not. Our system administrator has gone home for the day and given his state earlier I really would rather not bother him.
我正在创建我们的测试 Oracle DB（均为 10g）的副本并遇到一个问题，即我们的测试数据库安装了 UTL_SMTP 和 UTL_FILE 系统包，而我的本地 OracleXE 版本没有。我们的系统管理员今天已经回家了，根据他的状态，我真的不想打扰他。
How do I get these packages on my local OracleXE instance? I need to know where to download them as well as how to install them. Hopefully granting permissions I can figure out myself ;)
如何在本地 OracleXE 实例上获取这些包？我需要知道在哪里下载它们以及如何安装它们。希望授予权限我可以弄清楚自己;)
回答by cagcowboy
Files are:
文件是：
$ORACLE_HOME/rdbms/admin/utlsmtp.sql $ORACLE_HOME/rdbms/admin/utlfile.sql
$ORACLE_HOME/rdbms/admin/utlsmtp.sql $ORACLE_HOME/rdbms/admin/utlfile.sql
Run as SYS in SQL*Plus
在 SQL*Plus 中以 SYS 身份运行
