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

Report message to a moderator

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: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Both are just tools to interact with database.
You can do however you want.

Report message to a moderator

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.

Report message to a moderator

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: 68650
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

Report message to a moderator

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

Report message to a moderator

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.

Report message to a moderator

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: 68650
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Can you search a little bit?

Regards
Michel

Report message to a moderator

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

Report message to a moderator

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.

Report message to a moderator

Previous Topic: RedHat version Difference (Problem with sqldr)
Next Topic: How to add extended values in control file
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat May 11 23:14:58 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.