Type | Name and description |
---|---|
boolean |
additionsonly If set to true Orcas will only apply statics changes that extend the database schema. |
java.lang.String |
charsetname Character set used for sql-files. |
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. |
java.lang.String |
dateformat The data format. |
boolean |
dbdocPlantuml If set to true, orcas will generat platuml-sytle diagrams instead of using graphiz and html. |
boolean |
dropmode If set to true, Orcas will drop tables and columns even if they contain data. |
java.lang.String |
excludewherefunction A where-fragment for excluding functions from the model read from the database. |
java.lang.String |
excludewheregrant A where-fragment for excluding grants from the model read from the database. |
java.lang.String |
excludewheremview A where-fragment for excluding materialized views from the model read from the database. |
java.lang.String |
excludewhereobjecttype A where-fragment for excluding object types from the model read from the database. |
java.lang.String |
excludewherepackage A where-fragment for excluding packages from the model read from the database. |
java.lang.String |
excludewhereprocedure A where-fragment for excluding procedures from the model read from the database. |
java.lang.String |
excludewheresequence A where-fragment for excluding sequences from the model read from the database. |
java.lang.String |
excludewheresynonym A where-fragment for excluding synonyms from the model read from the database. |
java.lang.String |
excludewheretable A where-fragment for excluding tables from the model read from the database. |
java.lang.String |
excludewheretrigger A where-fragment for excluding trigger from the model read from the database. |
java.lang.String |
excludewhereview A where-fragment for excluding views from the model read from the database. |
de.opitzconsulting.orcas.diff.ExecuteSqlErrorHandler |
executeSqlErrorHandler Extended control of error handling. |
de.opitzconsulting.orcas.diff.ExtensionHandler |
extensionHandler A custom extension-handler. |
java.lang.String |
extensionparameter Can be used to parameterize custom extensions. |
java.lang.String |
extractgrantsfile The name of the extracted grants (not used by the orcas-gradle-plugin). |
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. |
java.lang.String |
extractreplaceablesoutfolder The name of the extracted replaceables base folder. |
java.lang.String |
extractstaticsoutfolder The name of the extracted statics base folder. |
java.lang.String |
extractsynonymsfile The name of the extracted synonyms (not used by the orcas-gradle-plugin). |
FailOnErrorMode |
failOnErrorMode Enum to control error handling. |
boolean |
indexmovetablespace If set to true, Orcas will move indexes to their new tablespaces. |
boolean |
indexonlinecreate If set to true, Orcas will create indexes online. |
boolean |
indexparallelcreate If set to true, Orcas will create indexes with the parallel option to improve performance. |
boolean |
isExtractViewCommnents If set to false, Orcas will extract comments for views. |
boolean |
isExtractViewCommnets @deprecated |
boolean |
isOneTimeScriptLogonlyMode If set to true, orcas will mark one-time-scripts as executed without executing them. |
java.lang.String |
jdbcdriver JDBC-Driver class of the database. |
java.lang.String |
jdbcurl JDBC-URL of the database. |
boolean |
logCompileErrors If set to false, compile errors are not shown. |
boolean |
logignoredstatements If set to true Orcas will log ignored statements as comments in the spoolfolder. |
java.lang.String |
loglevel loglevel. |
boolean |
logonly If set to true, the detected statics DDL-statements are only written to the log files. |
boolean |
minimizestatementcount If set to true, Orcas will try to put multiple changes to tables in a single DDL-statement. |
boolean |
multischema If set to true, Orcas can handle multiple schemas in a single statics run. |
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. |
java.lang.String |
multischemaexcludewhereowner If multischema is used, Orcas uses this as an where-fragment to exclude data-dictinary. |
boolean |
mviewlogmovetablespace If set to true, Orcas will recretae mview-logs if they are stored in a diffenrent tablespace. |
java.lang.String |
orcasjdbcdriver Driver class for the one-time-script ORCAS_UPDATES table. |
java.lang.String |
orcasjdbcurl JDBC-Url for the one-time-script ORCAS_UPDATES table. |
java.lang.String |
orcaspassword Password for the one-time-script ORCAS_UPDATES table. |
java.lang.String |
orcasusername Username for the one-time-script ORCAS_UPDATES table. |
java.lang.String |
password password of the database. |
java.lang.String |
replaceablesfolder The folder for replaceables used by the orcas-gradle-plugin. |
java.lang.String |
scriptfolderPostfix Ending for script-files. |
java.lang.String |
scriptfolderPrefix Start for script-files. |
boolean |
scriptfolderrecursive Search for script-files in subfolders?. |
boolean |
setunusedinsteadofdropcolumn If set to true, Orcas will set colums to unused instead of dropping them. |
java.lang.String |
spoolfile spoolfile. |
java.lang.String |
spoolfolder The Subfolder of the gradle build-folder for spoolfiles. |
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. |
boolean |
tablemovetablespace If set to true, Orcas will move tables to their new tablespaces. |
java.lang.String |
targetplsql @deprecated |
boolean |
updateEnabledStatus If set to true, Orcas will enable or disable constraints as given in the statics scripts. |
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. |
java.lang.String |
xmlinputfile |
java.lang.String |
xmllogfile The log-file for statics updates within the gradle build-dir. |
Methods inherited from class | Name |
---|---|
class java.lang.Object |
java.lang.Object#wait(long, int), java.lang.Object#wait(), java.lang.Object#wait(long), java.lang.Object#equals(java.lang.Object), java.lang.Object#toString(), java.lang.Object#hashCode(), java.lang.Object#getClass(), java.lang.Object#notify(), java.lang.Object#notifyAll() |
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
Character set used for sql-files. default: "UTF-8"
Can be set to change the character set used for spool files only.
If set to true, Orcas will create indexes for foreign-key columns that are not indexed. default: true
The data format. default: "dd.mm.yy"
If set to true, orcas will generat platuml-sytle diagrams instead of using graphiz and html. default: false
If set to true, Orcas will drop tables and columns even if they contain data. default: false
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)
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)"
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 '%$%'"
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)
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)
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)
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 '%$%'"
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))"
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 '%$%'"
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)
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)
Extended control of error handling. default: An error-handler using the failOnErrorMode
A custom extension-handler.
Can be used to parameterize custom extensions. default: ""
The name of the extracted grants (not used by the orcas-gradle-plugin). default: "extract/scripts/grants/grants.sql"
Used mainly for the domain-extension to specify the domains to apply during extract.
If set to true, Orcas removes all default values from extracted statics. default: true
The name of the extracted replaceables base folder. default: "extract/sql/replaceables"
The name of the extracted statics base folder. default: "extract/sql/statics"
The name of the extracted synonyms (not used by the orcas-gradle-plugin). default: "extract/scripts/synonyms/synonyms.sql"
Enum to control error handling. Only used if executeSqlErrorHandler is not set. default: FailOnErrorMode.ALWAYS
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
If set to true, Orcas will create indexes online. default: false
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
If set to false, Orcas will extract comments for views. default: false
If set to true, orcas will mark one-time-scripts as executed without executing them. default: false
JDBC-Driver class of the database. default: "oracle.jdbc.OracleDriver"
JDBC-URL of the database.
If set to false, compile errors are not shown. default: true
If set to true Orcas will log ignored statements as comments in the spoolfolder. default: true
loglevel. Possible values: error, warn, info, debug default: "info"
If set to true, the detected statics DDL-statements are only written to the log files. default: false
If set to true, Orcas will try to put multiple changes to tables in a single DDL-statement. default: false
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
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
If multischema is used, Orcas uses this as an where-fragment to exclude data-dictinary. The where-fragment may only use the "owner"-column.
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
Driver class for the one-time-script ORCAS_UPDATES table. default: "oracle.jdbc.OracleDriver"
JDBC-Url for the one-time-script ORCAS_UPDATES table. default: null so jdbcurl is used
Password for the one-time-script ORCAS_UPDATES table. default: null so password is used
Username for the one-time-script ORCAS_UPDATES table. default: null so username is used
password of the database.
The folder for replaceables used by the orcas-gradle-plugin. default: "src/main/sql/replaceables"
Ending for script-files. default: ".sql"
Start for script-files. default: "" meaning no filter
Search for script-files in subfolders?. default: true
If set to true, Orcas will set colums to unused instead of dropping them. default: false
spoolfile. default: "orcas_spoolfile.sql"
The Subfolder of the gradle build-folder for spoolfiles. default: "log/"
Can be used to do a static comparison with another schema instead of script files.
Can be used to do a static comparison with another schema instead of script files.
Can be used to do a static comparison with another schema instead of script files.
The folder for statics used by the orcas-gradle-plugin. default: "src/main/sql/statics"
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
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
username of the database.
If set to "text", Orcas will only extract the source of the views. Can be "text" or "full". default: "text"
The log-file for statics updates within the gradle build-dir. default: "log.xml"