Home » RDBMS Server » Server Utilities » Stored Procs Deployment (Oracle,9i,windows xp)
Stored Procs Deployment [message #329689] Thu, 26 June 2008 04:14 Go to next message
fakru.y
Messages: 34
Registered: May 2007
Member
How to deploy the stored procs from one environment to other environment i.e from Production to Development


Either using TOAD or SQL*PLUS

Any Help greatly appreciated
Re: Stored Procs Deployment [message #329702 is a reply to message #329689] Thu, 26 June 2008 05:09 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Both are just tools to interact with database.
You can do however you want.
Re: Stored Procs Deployment [message #329747 is a reply to message #329689] Thu, 26 June 2008 07:29 Go to previous messageGo to next message
fakru.y
Messages: 34
Registered: May 2007
Member
Can i have the steps how to deploy the entire stored procs in one environment database to other environment database.
Re: Stored Procs Deployment [message #329756 is a reply to message #329747] Thu, 26 June 2008 07:37 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use dbms_metadata to get the procedure definition, save it in a file and execute it in the other database.

Regards
Michel
Re: Stored Procs Deployment [message #329761 is a reply to message #329756] Thu, 26 June 2008 07:45 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> Either using TOAD or SQL*PLUS
And TOAD has facilities to extract the ddl for procedures.
Re: Stored Procs Deployment [message #329763 is a reply to message #329689] Thu, 26 June 2008 07:51 Go to previous messageGo to next message
fakru.y
Messages: 34
Registered: May 2007
Member
can i have any steps to generate a script for the entire database by using Toad tool, so that we can execute the entire script at a time.
Re: Stored Procs Deployment [message #329765 is a reply to message #329763] Thu, 26 June 2008 07:53 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Can you search a little bit?

Regards
Michel
Re: Stored Procs Deployment [message #329769 is a reply to message #329763] Thu, 26 June 2008 08:06 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
fakru.y wrote on Thu, 26 June 2008 08:51
can i have any steps to generate a script for the entire database by using Toad tool, so that we can execute the entire script at a time.


A simple SELECT statement will do.
Re: Stored Procs Deployment [message #329774 is a reply to message #329689] Thu, 26 June 2008 08:26 Go to previous message
fakru.y
Messages: 34
Registered: May 2007
Member
Thanks all for your quick response.
Any mistakes apolize me.
Previous Topic: RedHat version Difference (Problem with sqldr)
Next Topic: How to add extended values in control file
Goto Forum:
  


Current Time: Mon Dec 05 21:04:24 CST 2016

Total time taken to generate the page: 0.05362 seconds