Home » SQL & PL/SQL » SQL & PL/SQL » Load new packages into a schema using a database link
Load new packages into a schema using a database link [message #37327] Thu, 31 January 2002 01:57 Go to next message
Jens Vogelgesang
Messages: 23
Registered: January 2002
Junior Member
Hi all,
is there a way to compile new packages into a schema by using a database link???
We've several schemas which need to be updated frequently. I want to do this automatically.
Is there a way to do this?

Report message to a moderator

Re: Load new packages into a schema using a database link [message #37333 is a reply to message #37327] Thu, 31 January 2002 04:06 Go to previous messageGo to next message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
create script file with all modified package files and run that file on both servers.

ex:
script file: (script.sql)

@pkg1.sql
@pkg2.sql

run script.sql on both db servers.

Report message to a moderator

Re: Load new packages into a schema using a database link [message #37340 is a reply to message #37333] Thu, 31 January 2002 20:00 Go to previous message
Jens Vogelgesang
Messages: 23
Registered: January 2002
Junior Member
With a script this will work, but I want doo do this from a plsql program. I need to do some action before.

Report message to a moderator

Previous Topic: oracle instance... (please reply!!!)
Next Topic: How to
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 21 10:45:34 CDT 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.