mardi 3 mars 2015

Removing editioning from an Oracle user


I maintain an Oracle Enterprise 11.2.0.3 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?





Aucun commentaire:

Enregistrer un commentaire