Hi
I have both Master and Work repository connected on the same ODI_DEV_REPO schema . Now I need to create an additional new work repository. Ideally I want to this new work repository attached to the existing master. But, I read from the oracle documentation that we cannot have 2 different work repositories in the same schema. So the only options are,
Option1: Create 2 new schemas one for ODI_TEST_REPO_MASTER (master repository) and another for ODI_TEST_REPO_WORK (work repository)
Option 2: create ODI_TEST_REPO schema and make this master and work repository, similar to what I have now.
I just wanted to know if there are some other options here?
Note: I have ODI 12c 12.2.1.2.6 with standalone agent running on Linux system.