OraFAQ Forum: Server Administration » Moving p-code of an stored procedure from test server to production server in oracle 8i

Home » RDBMS Server » Server Administration » Moving p-code of an stored procedure from test server to production server in oracle 8i

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Moving p-code of an stored procedure from test server to production server in oracle 8i [message #59071]

Mon, 27 October 2003 05:26

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

Report message to a moderator

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

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 ..

Report message to a moderator

Previous Topic:	OUI alert installing Oracle 9i on HP Tru64
Next Topic:	Histogram

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jan 21 10:59:34 CST 2025