OraFAQ Forum: SQL & PL/SQL » Multiple versions of PL/SQL management

Home » SQL & PL/SQL » SQL & PL/SQL » Multiple versions of PL/SQL management

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

Multiple versions of PL/SQL management [message #575588]

Thu, 24 January 2013 08:59

lyangee
Messages: 1
Registered: January 2013

Junior Member

Hi

I am looking for advice on the best way to structure my schemas within a single Oracle instance to support multiple project development.
At the moment, within an Oracle instance I have Area_Dev and Area1_Test schemas, with the intention that Project Xv1.0 would use Dev schema for development and Test schema for testing.
Lets say I want to start on Project Xv2.0 development while I am still finalising Project Xv.10 development what is the best way of accommodating that, without creating individual schemas for each project?

Thanks

LY

Report message to a moderator

Re: Multiple versions of PL/SQL management [message #575590 is a reply to message #575588]

Thu, 24 January 2013 09:14

BlackSwan
Messages: 20247
Registered: January 2009

Senior Member

separate schema is best way.
You are free to choose other solution.
If so, then please post it here.

Report message to a moderator

Re: Multiple versions of PL/SQL management [message #575598 is a reply to message #575588]

Thu, 24 January 2013 10:53

Michel Cadot
Messages: 54722
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

If you are in 11.2 you can also use EDITIONs.

Regards
Michel

Report message to a moderator

Re: Multiple versions of PL/SQL management [message #575605 is a reply to message #575598]

Thu, 24 January 2013 11:07

cookiemonster
Messages: 9292
Registered: September 2008
Location: Rainy Manchester

Senior Member

For multiple simultaneous development and testing I would imagine editions would just unecessarily complicate matters.

OP: Any reason you can't just have another instance? That would be the simple solution.

Report message to a moderator

Previous Topic:	online shopping catalogue system
Next Topic:	Export_Data_From_Table_To_Different_Excel

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jun 20 07:32:02 CDT 2013

Total time taken to generate the page: 0.19842 seconds