| Note | ||
|---|---|---|
| ||
This information is now maintained in the product documentation: Oracle Database Objects and Packaging |
Oracle Guidelines
- 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
...
| Object Type | Packaging Folder | Archived? | Notes | ||
|---|---|---|---|---|---|
| CREATE/ALTER/DROP DATABASE LINK | /sql_direct | Yes | |||
| CREATE/ALTER/DROP FUNCTION | /function | No | Each function must be ended by a '/' on its own line. | ||
| CREATE/ALTER/DROP INDEX | /ddl /ddl_direct /sql_direct | Yes | |||
| CREATE/ALTER/DROP PROCEDUREQUEUE | /procedureEach procedure must be ended by a '/' on its own line.sql_direct | Yes | |||
| CREATE/ALTER/DROP QUEUESEQUENCE | /ddl /ddl_direct /sql_direct | Yes | |||
| CREATE/ALTER/DROP SEQUENCE PUBLIC SYNONYM | /ddl sql_direct | Yes | Alternatively, use Datical Auto-Synonyms | ||
| CREATE/ALTER/DROP | SYNONYMPUBLIC SYNONYM | /ddl | Alternatively/ddl_direct /sql_direct | Yes | Alternatively, use Datical Auto-Synonyms |
CREATE/ALTER/DROP TABLE | /ddl /ddl_direct /sql_direct | Yes | |||
| CREATE/ALTER/DROP GLOBAL TEMPORARY TABLE | /ddl /ddl_direct /sql_direct | Yes | |||
| CREATE/ALTER/DROP MATERIALIZED VIEW | /sql_direct | Yes | |||
| CREATE/ALTER/DROP PACKAGE | /package | No | Each package must be ended by a '/' on its own line. | ||
| CREATE/ALTER/DROP PACKAGE BODY | /packagebody | No | Each package body must be ended by a '/' on its own line. | ||
| CREATE/ALTER/DROP PROCEDURE | /procedure | No | Each procedure must be ended by a '/' on its own line. | ||
| CREATE/ALTER/DROP TRIGGER | /trigger | No | Each trigger must be ended by a '/' on its own line. | ||
| CREATE/ALTER/DROP TYPE | /sql_direct | Yes | Each type must be ended by a '/' on its own line. | ||
| CREATE/ALTER/DROP VIEW | /view | No | |||
| CREATE/ALTER/DROP VIEW INDEX | /ddl /ddl_direct /sql_direct | Yes | |||
| CREATE/ALTER/DROP CURSOR | /sql_direct | Yes | |||
| CREATE/ALTER/DROP DIRECTORY | /sql_direct | Yes | |||
| RENAME <DB_OBJECT> | /sql_direct | Yes |
| Operation | Packaging Folder | Archived? | Notes |
|---|---|---|---|
| INSERT, UPDATE, DELETE, SELECT | /data_dml | Yes | |
| GRANT, REVOKE | /sql_direct | Yes | Alternatively, use Datical Auto-Permissions |