Property Detail

• boolean additionsonly

  If set to true Orcas will only apply statics changes that extend the database schema. In this mode tables and columns are usually added, whereas constraints are usually dropped. There are some database-changes that lead to an errror in this mode (e.g. changing column datatypes). default: false

• java.lang.String charsetname

  Character set used for sql-files. default: "UTF-8"

• java.lang.String charsetnamesqllog

  Can be set to change the character set used for spool files only.

• boolean createmissingfkindexes

  If set to true, Orcas will create indexes for foreign-key columns that are not indexed. default: true

• java.lang.String dateformat

  The data format. default: "dd.mm.yy"

• boolean dbdocPlantuml

  If set to true, orcas will generat platuml-sytle diagrams instead of using graphiz and html. default: false

• boolean dropmode

  If set to true, Orcas will drop tables and columns even if they contain data. default: false

• java.lang.String excludewherefunction

  A where-fragment for excluding functions from the model read from the database. The where-fragment is applied to the user_objects data dictionary view. default: "1 = 0" (nothing is excluded)

• java.lang.String excludewheregrant

  A where-fragment for excluding grants from the model read from the database. The where-fragment is applied to the all_tab_privs_made data dictionary view. default: "not(owner = user)"

• java.lang.String excludewheremview

  A where-fragment for excluding materialized views from the model read from the database. The where-fragment is applied to the user_objects data dictionary view. default: "object_name like '%$%'"

• java.lang.String excludewhereobjecttype

  A where-fragment for excluding object types from the model read from the database. The where-fragment is applied to the user_objects data dictionary view. default: "1 = 0" (nothing is excluded)

• java.lang.String excludewherepackage

  A where-fragment for excluding packages from the model read from the database. The where-fragment is applied to the user_objects data dictionary view. default: "1 = 0" (nothing is excluded)

• java.lang.String excludewhereprocedure

  A where-fragment for excluding procedures from the model read from the database. The where-fragment is applied to the user_objects data dictionary view. default: "1 = 0" (nothing is excluded)

• java.lang.String excludewheresequence

  A where-fragment for excluding sequences from the model read from the database. The where-fragment is applied to the user_objects data dictionary view. default: "object_name like '%$%'"

• java.lang.String excludewheresynonym

  A where-fragment for excluding synonyms from the model read from the database. The where-fragment is applied to the all_synonyms data dictionary view. default: "not((owner = user) or (owner = 'PUBLIC' and table_owner = user and db_link is null))"

• java.lang.String excludewheretable

  A where-fragment for excluding tables from the model read from the database. The where-fragment is applied to the user_objects data dictionary view. default: "object_name like '%$%'"

• java.lang.String excludewheretrigger

  A where-fragment for excluding trigger from the model read from the database. The where-fragment is applied to the user_objects data dictionary view. default: "1 = 0" (nothing is excluded)

• java.lang.String excludewhereview

  A where-fragment for excluding views from the model read from the database. The where-fragment is applied to the user_objects data dictionary view. default: "1 = 0" (nothing is excluded)

• de.opitzconsulting.orcas.diff.ExecuteSqlErrorHandler executeSqlErrorHandler

  Extended control of error handling. default: An error-handler using the failOnErrorMode

• de.opitzconsulting.orcas.diff.ExtensionHandler extensionHandler

  A custom extension-handler.

• java.lang.String extensionparameter

  Can be used to parameterize custom extensions. default: ""

• java.util.List<java.util.function.UnaryOperator<de.opitzconsulting.orcasDsl.Model>> extensions

  List of Extensions. default: empty list

• java.lang.String extractgrantsfile

  The name of the extracted grants (not used by the orcas-gradle-plugin). default: "extract/scripts/grants/grants.sql"

• java.lang.String extractmodelinputfolder

  Used mainly for the domain-extension to specify the domains to apply during extract.

• boolean extractremovedefaultvaluesfrommodel

  If set to true, Orcas removes all default values from extracted statics. default: true

• java.lang.String extractreplaceablesoutfolder

  The name of the extracted replaceables base folder. default: "extract/sql/replaceables"

• java.lang.String extractstaticsoutfolder

  The name of the extracted statics base folder. default: "extract/sql/statics"

• java.lang.String extractsynonymsfile

  The name of the extracted synonyms (not used by the orcas-gradle-plugin). default: "extract/scripts/synonyms/synonyms.sql"

• FailOnErrorMode failOnErrorMode

  Enum to control error handling. Only used if executeSqlErrorHandler is not set. default: FailOnErrorMode.ALWAYS

• boolean indexmovetablespace

  If set to true, Orcas will move indexes to their new tablespaces. If set to false, Orcas will not change indexes if they are stored in a diffenrent tablespace. default: true

• boolean indexonlinecreate

  If set to true, Orcas will create indexes online. default: false

• boolean indexparallelcreate

  If set to true, Orcas will create indexes with the parallel option to improve performance. Note that after the index is created the parallel option will be reset. default: true

• boolean isExtractViewCommnents

  If set to false, Orcas will extract comments for views. default: false

• boolean isExtractViewCommnets

  deprecated:

• boolean isOneTimeScriptLogonlyMode

  If set to true, orcas will mark one-time-scripts as executed without executing them. default: false

• java.lang.String jdbcdriver

  JDBC-Driver class of the database. default: "oracle.jdbc.OracleDriver"

• java.lang.String jdbcurl

  JDBC-URL of the database.

• boolean logCompileErrors

  If set to false, compile errors are not shown. default: true

• boolean logignoredstatements

  If set to true Orcas will log ignored statements as comments in the spoolfolder. default: true

• java.lang.String loglevel

  loglevel. Possible values: error, warn, info, debug default: "info"

• boolean logonly

  If set to true, the detected statics DDL-statements are only written to the log files. default: false

• boolean minimizestatementcount

  If set to true, Orcas will try to put multiple changes to tables in a single DDL-statement. default: false

• boolean multischema

  If set to true, Orcas can handle multiple schemas in a single statics run. Object names may need to be prefixed with a schema name in this mode. default: false

• boolean multischemadbaviews

  If multischema is used and set to true, Orcas will use the dba_ views instead of the all_views for extracting data-dictinary data. Note that multischemaexcludewhereowner is required if set to true. default: false

• java.lang.String multischemaexcludewhereowner

  If multischema is used, Orcas uses this as an where-fragment to exclude data-dictinary. The where-fragment may only use the "owner"-column.

• boolean mviewlogmovetablespace

  If set to true, Orcas will recretae mview-logs if they are stored in a diffenrent tablespace. If set to false, Orcas will not change mview-logs if they are stored in a diffenrent tablespace. default: false

• java.lang.String orcasjdbcdriver

  Driver class for the one-time-script ORCAS_UPDATES table. default: "oracle.jdbc.OracleDriver"

• java.lang.String orcasjdbcurl

  JDBC-Url for the one-time-script ORCAS_UPDATES table. default: null so jdbcurl is used

• java.lang.String orcaspassword

  Password for the one-time-script ORCAS_UPDATES table. default: null so password is used

• java.lang.String orcasusername

  Username for the one-time-script ORCAS_UPDATES table. default: null so username is used

• java.lang.String password

  password of the database.

• java.lang.String replaceablesfolder

  The folder for replaceables used by the orcas-gradle-plugin. default: "src/main/sql/replaceables"

• java.util.List<java.util.function.UnaryOperator<de.opitzconsulting.orcasDsl.Model>> reverseExtensions

  List of Reverse-Extensions. default: empty list

• java.lang.String scriptfolderPostfix

  Ending for script-files. default: ".sql"

• java.lang.String scriptfolderPrefix

  Start for script-files. default: "" meaning no filter

• boolean scriptfolderrecursive

  Search for script-files in subfolders?. default: true

• boolean setunusedinsteadofdropcolumn

  If set to true, Orcas will set colums to unused instead of dropping them. default: false

• java.lang.String spoolfile

  spoolfile. default: "orcas_spoolfile.sql"

• java.lang.String spoolfolder

  The Subfolder of the gradle build-folder for spoolfiles. default: "log/"

• java.lang.String srcjdbcurl

  Can be used to do a static comparison with another schema instead of script files.

• java.lang.String srcpassword

  Can be used to do a static comparison with another schema instead of script files.

• java.lang.String srcusername

  Can be used to do a static comparison with another schema instead of script files.

• java.lang.String staticsfolder

  The folder for statics used by the orcas-gradle-plugin. default: "src/main/sql/statics"

• boolean tablemovetablespace

  If set to true, Orcas will move tables to their new tablespaces. If set to false, Orcas will not change tables if they are stored in a diffenrent tablespace. default: true

• java.lang.String targetplsql

  deprecated:

• boolean updateEnabledStatus

  If set to true, Orcas will enable or disable constraints as given in the statics scripts. If set to false, Orcas will not cnahe the enabled state of constraints. default: false

• java.lang.String username

  username of the database.

• java.lang.String usernameorcas

  deprecated:

• java.lang.String viewextractmode

  If set to "text", Orcas will only extract the source of the views. Can be "text" or "full". default: "text"

• java.lang.String xmlinputfile

• java.lang.String xmllogfile

  The log-file for statics updates within the gradle build-dir. default: "log.xml"