...
- For an Oracle Default Schema (single-schema) Project, database objects can be either fully qualified or unqualified with the schema name. If they are left unqualified, Datical DB will deploy the changes into the Connection Schema, or the Default Schema (if specified).
- For an Oracle Multi-Schema Project, database objects must be fully qualified with the schema name so they get deployed to the correct schema during packaging.
- You can use the schemaName attribute in the metadata.properties to indicate the default schema for all the scripts in the folder where the metadata.properties reside and its children as well.
Oracle SCM Packaging Patterns
...