Forum Stats

  • 3,837,263 Users
  • 2,262,245 Discussions
  • 7,900,240 Comments

Discussions

sqlcl errors while using -synonyms -grants anf when these flags are removed error go away

AMAL_AG
AMAL_AG Member Posts: 3 Green Ribbon

My schema only has two tables create from dba_users

SQL> tables


  TABLES

_________

EMP

EMP1



 lb genschema -split -sql -synonyms -grants -label test1



--Starting Liquibase at 09:29:02 (version 4.9.1 #0 built at 2022-05-03 17:23+0000)



Export Flags Used:


Export Grants      true

Export Synonyms     true


[Method loadCaptureTable]:

    [Type - TYPE_SPEC]:             46 ms

    [Type - TYPE_BODY]:             41 ms

    [Type - SEQUENCE]:             37 ms

    [Type - DIRECTORY]:             36 ms

    [Type - CLUSTER]:              45 ms

    [Type - TABLE]:              502 ms

    [Type - MATERIALIZED_VIEW_LOG]:       38 ms

    [Type - MATERIALIZED_VIEW]:         30 ms

    [Type - VIEW]:               46 ms

    [Type - REF_CONSTRAINT]:          38 ms

    [Type - DIMENSION]:             38 ms

    [Type - FUNCTION]:             42 ms

    [Type - PROCEDURE]:             40 ms

    [Type - PACKAGE_SPEC]:           40 ms

    [Type - DB_LINK]:              36 ms

    [Type - SYNONYM]:              39 ms

    [Type - INDEX]:               43 ms

    [Type - TRIGGER]:              41 ms

    [Type - PACKAGE_BODY]:           47 ms

    [Type - JOB]:                35 ms

    [Type - PUBLIC_SYNONYM]:         15209 ms

    [Type - OBJECT_GRANT]:           40 ms


[Method loadCaptureTable]:            16509 ms

[Method processCaptureTable]:          417925 ms

[Method sortCaptureTable]: ORA-00001: unique constraint (AMAL_TEST.DATABASECHANGELOG_EXPORT_PK) violated

ORA-06512: at "AMAL_TEST.SQLCL_LB_CAPTURE", line 205



ORA-00001: unique constraint (AMAL_TEST.DATABASECHANGELOG_EXPORT_PK) violated

ORA-06512: at "AMAL_TEST.SQLCL_LB_CAPTURE", line 205



ORA-00001: unique constraint (AMAL_TEST.DATABASECHANGELOG_EXPORT_PK) violated

ORA-06512: at "AMAL_TEST.SQLCL_LB_CAPTURE", line 205

===============================================================

with out grant and synonyms

-----------------------

lb genschema -split -label test1 -sql



--Starting Liquibase at 10:11:43 (version 4.9.1 #0 built at 2022-05-03 17:23+0000)



Export Flags Used:


Export Grants      false

Export Synonyms     false


[Method loadCaptureTable]:

    [Type - TYPE_SPEC]:             84 ms

    [Type - TYPE_BODY]:             49 ms

    [Type - SEQUENCE]:             41 ms

    [Type - DIRECTORY]:             40 ms

    [Type - CLUSTER]:              49 ms

    [Type - TABLE]:              575 ms

    [Type - MATERIALIZED_VIEW_LOG]:       44 ms

    [Type - MATERIALIZED_VIEW]:         33 ms

    [Type - VIEW]:               48 ms

    [Type - REF_CONSTRAINT]:          42 ms

    [Type - DIMENSION]:             43 ms

    [Type - FUNCTION]:             45 ms

    [Type - PROCEDURE]:             45 ms

    [Type - PACKAGE_SPEC]:           46 ms

    [Type - DB_LINK]:              42 ms

    [Type - SYNONYM]:              47 ms

    [Type - INDEX]:               46 ms

    [Type - TRIGGER]:              51 ms

    [Type - PACKAGE_BODY]:           54 ms

    [Type - JOB]:                43 ms


[Method loadCaptureTable]:            1467 ms

[Method processCaptureTable]:           2491 ms

[Method sortCaptureTable]:             51 ms

[Method cleanupCaptureTable]:            34 ms

[Method writeChangeLogs]:             2099 ms