I have a question regarding the behaviour of CREATE DATABASE when used with TEMPLATE and TABLESPACE options together. The documentation describes the tablespace parameter as: The name of the tablespace that will be associated with the new database, or DEFAULT to use the template database's tablespace. This tablespace will be the default tablespace used for objects created in this database. See CREATE TABLESPACE for more information. I would take that to mean that all objects from the template will be created in the new database within the specified tablespace. However it seems this is not the case, and that the newly specified tablespace will only apply to objects that do not already have a tablespace defined in the templated database. Is this a documentation issue, or a behavioural one? It isn't clear to me. |
