I maintain an Oracle Enterprise 18.104.22.168 database where one user has editioning enabled. I understand that this was an irreversible choice according to the documentation.
If I wish to revert that user to a non-editioned status can I export their objects, drop and recreate the user and then import the old objects?
- Are there any consequences?
- Which edition will Oracle export?
- should I drop all child editions first?
This question is caused by the assessment of the team that editioning is not used and does not offer any benefits when we have generous time periods for scheduled downtimed. It prevents any materialized views being created by the editioned user if they select non editioned object from another user. This is required for one project due soon and a data warehouse in the near future.