Skip to Main Content

SQLcl

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

SQLCLI + Liquibase problems with an update on Always Free 23ai

YuriAPSep 10 2024 — edited Sep 11 2024

Hello

I am trying to do this basic example https://docs.oracle.com/en/database/oracle/sql-developer-command-line/24.1/sqcug/examples-using-liquibase.html#GUID-D4B11199-D4FB-460A-B9C7-71E498B921A8.

Tried: SQLCL 24.2, 24.1, 23.4, grabbing one schema and trying to create a copy of all objects in another schema of the same physical DB (12.1.0.2).

Also tried to run LB UPDATE at Always Free 23ai with 24.1 SQLCLI.

Every time different errors happen, starting from inability to run LB GENERATE-SCHEMA (24.2) to not be able to create most of the objects in the target schema (almost all tables were missed without error messages, although other objects: packages, types were created)

For example, currently trying to run using 24.1 SQLCLI at 23ai Always Free DB

lb update -changelog-file controller.xml

getting multiple errors like

, sda_sqlpp_r_idx1_index.xml::2f034a776da744bab4c00e5ab8c4aa08e93e16fe::(SQL_DATA_ANALYSIS)-Generated
         ORA-31011: XML parsing failed
ORA-19213: error occurred in XML processing at lines 34
LPX-00245: extra data after end of document
ORA-06512: at "SYS.XMLTYPE", line 272
ORA-06512: at line 96
, sda_sql_plc_idx1_index.xml::4a356355cc0c1240b6e4e954822dffbdbd3eefd9::(SQL_DATA_ANALYSIS)-Generated

I might be doing something fundamentally wrong…

Is there any good manual with step-by-step instruction taking one schema and reproducing it somewhere else?

I can re-run any experiment with debug an logging and present here the results

Comments
Post Details
Added on Sep 10 2024
5 comments
121 views