Data Science & Machine Learning

Would it be technically feasible to take the following approach?

Export all of the ODM schema using the Oracle Export Utility. Create a new user called, CSI_ODM. Import all of these objects From User [ODM] to User [CSI_ODM]. Use CSI_ODM as our schema in which to build our ODM-based application. Deliver CSI_ODM schema in its entirety when we deliver the application. This way we are preserving the ODM schema as it is delivered and we are protecting ourselves from the inevitable situation where the ODM schema gets dropped and recreated with a new release of ODM and we are keeping all of the necessary permission under one controlled user. Downside is that we have another copy of all of the ODM objects in the database and if updates to ODM occur that we want to take advantage of, we will need to export, import and re-add our custom objects. But this is the only solution that I could think of under the current ODM 9iR2 architecture.


Thanks,
Dianna