How do I prevent flyway from creating the schema during init -
i'm trying start using flyway v2.3 on existing oracle 11g schema not contain schema_history table
in flyway.properties i've set flyway.user schema owner , i've set flyway.schemas property same value
when running init command line expected flyway create schema_history table fails message:
$ ./flyway.cmd init flyway (command-line tool) v.2.3 creating schema "myschema" ... error: unable create schema "myschema" error: caused by: java.sql.sqlsyntaxerrorexception: ora-01031: insufficient privileges
why flyway attempting create schema? want create schema_history table in schema configured
the command correct. please note flyway.schemas case-sensitive , automatically filled default schema of user if left empty.
i suspect value put in flyway.schemas in wrong case. leave empty , should ok.
Comments
Post a Comment