Re: concurrent development on a database

rainer.hirthammer_at_software-objects.com (Rainer Hirthammer) wrote in news:3db81132.26656439_at_news.btx.dtag.de:

> (ORA 8.1.7) If anybody wants to edit e.g. a package we have to
> arrange with colleagues to avoid of overwriting by another. Is it
> possible to lock or hide packages?

This appears to be more of a software development question rather than an Oracle question. For example, if you had a gang of developers developing an application in C, if one file was used, it'd be tenuous to merge their changes.

Instead, what one does is functionally break the problem into separate physical files so that multiple developers can work in the respective areas. This methodology is glued together with a respectable software revision control system (such as CVS) and now you have source code control and concurrent development.

Given the above, you can have packages that correspond to discrete functions within your application and use source code control to control the revisions.

HTH!

-- 
Pablo Sanchez, High-Performance Database Engineering
http://www.hpdbe.com