OraFAQ Forum: SQL & PL/SQL » Is there a way to copy a stored procedure to another schema on a different server

Home » SQL & PL/SQL » SQL & PL/SQL » Is there a way to copy a stored procedure to another schema on a different server

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

Is there a way to copy a stored procedure to another schema on a different server [message #38256]

Thu, 04 April 2002 13:54

Mike Oakes
Messages: 25
Registered: December 2000

Junior Member

Hello,
Is it possible to copy a stored procedure from one schema to another on a different server. All databases are connected via net 8.

Thanks,
Mike o.

Report message to a moderator

Re: Is there a way to copy a stored procedure to another schema on a different server [message #38259 is a reply to message #38256]

Thu, 04 April 2002 17:47

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

u mean, copy from database to another?
simplest mean is to get the source code from the source database ( use dba_sources) and recreate it in the target database.
else u need to establish a database link,call the proceudre and recompile it in the target datbase.

Report message to a moderator

Re: Is there a way to copy a stored procedure to another schema on a different server [message #38296 is a reply to message #38256]

Mon, 08 April 2002 12:10

andrew again
Messages: 2577
Registered: March 2000

Senior Member

Using a tool like TOAD, you simply bring up the package (spec and body) or funct. / proc. in the procedure editor, swap connections to the new database and then compile.
Oracle's replication can replicate pl/sql code when it's changed on the master environment. I've never wanted to do that though.

Report message to a moderator

Previous Topic:	Dynamic resultset
Next Topic:	Inserted Value too large for column

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 19:04:32 CDT 2024