I am generating my DDL script for Oracle using Liquibase (using the liquibase in offline mode as specified here). When running the generated CREATE TABLE sql through sql plus, I am getting the following error
Regarding SP2-0027: Input is too long
This explains that we have to break the single line sql to multiple lines so that we can run such long sqls through sql plus.
Is there a way to break the single line sql in Liquibase?
The Sql plus version is Version 18.4.0.0.0
Edit : When I split the sql into two lines, it is successfully executing.