Home » SQL & PL/SQL » SQL & PL/SQL » Multiple versions of PL/SQL management
Multiple versions of PL/SQL management [message #575588] Thu, 24 January 2013 08:59 Go to next message
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
Re: Multiple versions of PL/SQL management [message #575590 is a reply to message #575588] Thu, 24 January 2013 09:14 Go to previous messageGo to next message
BlackSwan
Messages: 22547
Registered: January 2009
Senior Member
separate schema is best way.
You are free to choose other solution.
If so, then please post it here.
Re: Multiple versions of PL/SQL management [message #575598 is a reply to message #575588] Thu, 24 January 2013 10:53 Go to previous messageGo to next message
Michel Cadot
Messages: 58638
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you are in 11.2 you can also use EDITIONs.

Regards
Michel
Re: Multiple versions of PL/SQL management [message #575605 is a reply to message #575598] Thu, 24 January 2013 11:07 Go to previous message
cookiemonster
Messages: 10859
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.
Previous Topic: online shopping catalogue system
Next Topic: Export_Data_From_Table_To_Different_Excel
Goto Forum:
  


Current Time: Thu Jul 31 16:10:55 CDT 2014

Total time taken to generate the page: 0.14409 seconds