Home » RDBMS Server » Server Administration » Moving p-code of an stored procedure from test server to production server in oracle 8i
Moving p-code of an stored procedure from test server to production server in oracle 8i [message #59071] Mon, 27 October 2003 05:26 Go to next message
Suresh.H.T
Messages: 9
Registered: February 2002
Junior Member
Hi,
I want to Move p-code of an stored procedure from test server to production server in oracle 8i.
What is the best way to do it?
Hoping for an early solution.
Thanking you
Suresh.H.T
Re: Moving p-code of an stored procedure from test server to production server in oracle 8i [message #59082 is a reply to message #59071] Mon, 27 October 2003 12:51 Go to previous message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
You can extract the procedure into a file(using dba_source or all_source or user_source) and run it against production ..
Previous Topic: OUI alert installing Oracle 9i on HP Tru64
Next Topic: Histogram
Goto Forum:
  


Current Time: Fri Sep 20 08:42:33 CDT 2024