Oracle team development - is it possible to control versions, locks?

Question

Oracle

Good day, gentlemen!

At one fine moment, the team becomes large, and the project begins to consist of several hundred packages / views, etc. The ability to say "hey Vasya, do you edit such and such a package? No? I edit it then." begins to fall away because the development comes from several offices.

It is not possible to change the organizational process - at the same time, the same object can be accidentally changed and the code of the person that was the first is lost.

And if you imagine that there will be several branches of the subd structure?

There is no way for each developer to install the Express version - there is a single test server on which development is underway. Occasionally, the test server is upgraded to one of the working ones. And then all the same, the developer needs to monitor (schema compare) what he has and what is on the "common test".

I would like, by analogy with Team Foundation, to be able to edit packages with a lock from others, but at the same time some reflection of the current state was kept in the sql files that were updated as the objects themselves changed.
Project management is very well implemented in dbforge studio for oracle, but team development is not provided, and integration with tfs is frail to say the least.
ODAC with Oracle Developer Tools for Visual Studio is also endowed with working with subds directly from the studios and maintaining the project, but it does not update the project as the subd changes and you have to constantly monitor what is in the subd and what is in the project.

Is it possible to organize competent development in the Oracle subd using version control with locks from the random work of several people?

Answer 1

Check out this thread: What are some ways to link an Oracle database (packages, triggers, indexes, table structure, etc.) to a version control system (GIT, SVN)?
In my opinion, this is a discussion of your own question, but in a different formulation.