Those two are for development and testing box for the application and ultimately testing
box will be turned to a production box in future. I have Stored procedure
and function compiled in the development box and I wanted to transfer those
to testing box and compiled there.

Actually I don't want to do copy and paste form of action of Oracle Enterprize Manager, I will be doing
a lot of changes in the development box's procedures and functions in future so I am looking for script or tool which will enable me to retrieve the all compiled procedures and functions into file and I can do recompile in other box.

I am handling the both databases and have dba access but
I don't have experiences on DBA. I have created a user for the application and I am using that
user to access to the database and corresponding all objects.


SK