The property “default_spoolfolder” is set to an actual value (namely to the name of the directory), so the logging is now active. With active logging each task needs which is able to log (these are almost all except for “orcas_install” and “orcas_initialize”) a logname parameter. This should be unique. At the beginning of our build target the deletion of the spoolfolders is added.
We start our project as usual:
Result: The “log” directory was not even created. This is because Orcas performed no change to our scheme. That changes when we for example expand our table:
A subsequent ant call is then lead to the new column is created and this will be logged in our “log” directory. The “log” directory now contains a file “master_install.sql”. When you execute with SQL*Plus you get the same result in the respective schema as with ant. If we had previously copied our scheme (e.g. with import/export) and executed “master_install.sql” on it, then the scheme would have been also updated there.