I am trying to export fromschema and import it to newschema without data. The
-remapschemas fromschema=toschema
works, but Liquibase objects and triggers have dependencies with fromschema.
ORA-39083: Object type TRIGGER:"TOSCHEMA"."DATABASECHANGELOG_ACTIONS_TRG" failed to create with error:
What is the proper syntax to exclude objects by their names? I assume e.g. that for Liquibase the list of names would be like:
DATABASECHANGELOG,DATABASECHANGELOGLOCK,DATABASECHANGELOG_ACTIONS,DATABASECHANGELOG_ACTIONS_PK,DATABASECHANGELOG_ACTIONS_TRG
Alternatively have all objects imported but the objects with errors in invalid state? Now it seems bypass the objects which wont compile?
rgrds Paavo