How to install system packages into oracle?

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.

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 ;)

Answers


Files are:

$ORACLE_HOME/rdbms/admin/utlsmtp.sql $ORACLE_HOME/rdbms/admin/utlfile.sql

Run as SYS in SQL*Plus


Need Your Help

Javascript- How to return an array by with a string as parameter?

javascript arrays function

For a simple function, how can I return an array with a string as a parameter? I want the array to split the string at the spaces so it returns as [" ", " "].

Some images do not load under http, but do under https

ssl image iis-6

I've come across an issue where some images on a site load under https but do not load under http.