Skip to Main Content

SQLcl

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

SQLcl 23.4: lb ges -de -lo -sp -sq failes with "java.sql.SQLException: ORA-12899: value too large for column..."

Boris GlazyrinJan 31 2024

Hello!
I am trying to use sqlcl Liquibase with our schema. Previous versions worked extremely long (more then 4 hours) and often failed with different errors.

So I tried SQLcl 23.4. It seems, that Liquibase commands are much faster, but they still fails.

SQL> lb ges -de -lo -sp -sq
DEBUG: Logging enabled at LEVEL
--Starting Liquibase at 2024-01-31T03:56:50.557216200 (version [local build] #0 built at 2023-11-06 22:02+0000)

DEBUG: Starting LB command: GENERATE-SCHEMA

Export Flags Used:

Export Grants           false
Export Synonyms         false

[Method loadCaptureTable]:
        [Type - TYPE_SPEC]:                       5088 ms
        [Type - TYPE_BODY]:                        202 ms
        [Type - SEQUENCE]:                        5914 ms
        [Type - DIRECTORY]:                        105 ms
        [Type - CLUSTER]:                          442 ms
        [Type - TABLE]:                         119741 ms
        [Type - MATERIALIZED_VIEW_LOG]:           1405 ms
        [Type - MATERIALIZED_VIEW]:               5160 ms
        [Type - VIEW]:                           65649 ms
        [Type - REF_CONSTRAINT]:                  5337 ms
        [Type - DIMENSION]:                         21 ms
        [Type - PACKAGE_SPEC]:                    5394 ms
        [Type - FUNCTION]:                         417 ms
        [Type - PROCEDURE]:                       1469 ms
        [Type - DB_LINK]:                           67 ms
        [Type - SYNONYM]:                          222 ms
        [Type - INDEX]:                          95962 ms
        [Type - TRIGGER]:                         1164 ms

[Method loadCaptureTable]:                      323627 ms
java.sql.SQLException: ORA-12899: value too large for column "SED4"."DATABASECHANGELOG_EXPORT"."OBJECT_DEPS" (actual: 2008,\n DDL
DEBUG: Loggind Ended
Comments
Post Details
Added on Jan 31 2024
3 comments
70 views