This content has been marked as final. Show 3 replies
This is the same idea as the 'Export all scenarios' option available through the ODI Studio - but this is only available when connected to a development work repository. Your execution-only work repository will be missing tables that will only exist in a development repository and this could account for the error message - although there's nothing in the documentation for odiexportallscen that I can see to confirm that.
I've tried both export from working and from execution repository, same result. Maybe the oracle repo user is missing some privileges?!
So long as your work repo user has access to master repo user (and vice versa) they dont need to know of any others.