We are in the starting phase of implementing sqlcl projects in our environment.
We are struggling with the following situation:
Our applications use two schema's. Base schema is schema A (parsing schema for the older apex applications) the other schema is B (parsing schema for the newer applications). Schema A contains all tables (and a lot of plsql objects), schema B does not have any tables but only views on schema A (and a lot of plsql objects).
Our stories can consist of objects of both schema's
What is good practice in this case?
Two projects?
One extra schema, that has all needed privileges on the objects of schema's A and B?
Any advice appreciated
Regards Erik