- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 73 Insurance
- 537.3K On-Premises Infrastructure
- 138.6K Analytics Software
- 38.6K Application Development Software
- 6K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.2K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
Adding new work repository in an existing setup
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 18.104.22.168.6 with standalone agent running on Linux system.