Skip to Main Content

SQLcl: MCP Server & SQL Prompt

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

AMAL_AGJul 8 2022

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

Comments
Post Details
Added on Jul 8 2022
0 comments
155 views