Skip to Main Content

datapump - how to exclude Liquibase objects in export - SqlCL 22.3.1.0

PaavoDec 9 2022

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

Comments
Post Details
Added on Dec 9 2022
0 comments
15 views