Attaching and Detaching (Deleting) a Work Repository FAQS

1. What is a Work Repository in Oracle Data Integrator?

• A Work Repository in Oracle Data Integrator (ODI) stores data related to various tasks, such as mapping, integration, and execution logs. It is linked to a Master Repository, which manages metadata and other configurations.

 

2. What happens when I delete a Work Repository?

• Deleting a work repository detaches it from the master repository, meaning it is no longer linked, but the content of the repository itself is not deleted. The work repository’s data remains intact, but its connection to the master repository is removed.

 

3. Can I attach a work repository to more than one master repository?

• No, a work repository can only be attached to one master repository at a time. If you want to attach it to another master repository, you need to detach it from the current one first.

 

4. What should I do if the Test Connection fails during the attach process?

• If the connection test fails, ensure that:
• The JDBC URL is correct and the server is accessible.
• The JDBC driver matches the selected technology.
• The User ID and Password are correct and have the necessary privileges to create and access the repository.
• If the issue persists, verify the network settings or contact your database administrator for assistance.

 

5. What happens if I accidentally delete the wrong work repository?

• If you accidentally delete a work repository, the repository will simply be detached from the master repository. The data inside the repository is not destroyed. However, you would need to re-attach the correct repository by going through the "Attach" process again.

 

6. Can I delete a Work Repository while it is in use?

• It is generally recommended to ensure that the work repository is not in use (i.e., no tasks are running) before deleting it. Deleting a repository that is in use may cause issues with ongoing processes.

 

7. How do I reattach a previously detached work repository?

• You can reattach a detached work repository by following the same steps used for attaching a work repository, and simply provide the necessary credentials and details to reconnect it to the master repository.

 

8. Will the work repository password change when detaching or deleting?

• No, deleting or detaching a work repository does not change the password of the work repository. The password remains the same, and it is required when you reattach or access the repository again.

 

9. Is there any impact on data integrity when detaching or deleting a Work Repository?

• Detaching or deleting a work repository does not affect the integrity of the data stored in the repository. It only removes the link to the master repository and does not alter any stored data.

 

10. How can I confirm that the work repository has been successfully attached or deleted?

• After attaching a work repository, you can confirm its connection by checking the Repositories panel in the Topology Navigator to ensure it appears as attached. For deletion, confirm that the repository is no longer listed under the Work Repositories node in the same panel.