Dear all,
I’m starting with liquibase and Oracle data base and I have noticed that the dropAll command doesn’t drop all objects in the data base, for example in a Oracle 11r2, after a dropAll execution packages, functions, object types, collections and dblinks are not deleted in the data base.
Is that the standard behavior? Should these objects dopped also in a dropAll execution?
For packages, functions, object types, collections I can do a dropAll and after a update without problems, since all of those objects are created using create or replace. For dblinks, I need to do an additional check before update the data base after a dropAll, since create dblink in oracle has not a “replace”, for this reason I must include in the liquibase files an additional check to detect if the dblink is in the data base or not before recreate it.
Thanks in advance