| 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.
...
| 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 QUEUE | /sql_direct | Yes | |||
| CREATE/ALTER/DROP SEQUENCE | /ddl /ddl _direct /sql_direct | Yes | |||
| CREATE/ALTER/DROP PUBLIC SYNONYM | /sql_direct | Yes | Alternatively, use Datical Auto-Synonyms | ||
| CREATE/ALTER/DROP | SYNONYMPUBLIC SYNONYM | /ddl /ddl | Alternatively_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 |