Skip to end of metadata
  • Created by Former user, last modified by Former user on Sept 15, 2017
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 21 Next »

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.

Oracle SCM Packaging Patterns

Datical supports two development usage/packaging patterns:

  • Permanent - In-place editing, packaging and no archiving of database changes so they can be managed similar to application code. This applies to the following object types:
    • Procedures (when scripts are placed in the "/procedure" folder)
    • Functions (when scripts are placed in the "/function" folder)
    • Package (when scripts are placed in the "/package" folder)
    • Package Body (when scripts are placed in the "/packagebody" folder)
    • Views (when scripts are placed in the "/view" folder)
    • Triggers (when scripts are placed in the "/trigger" folder)
  • Transient - Database changes are archived after packaging (all other folders).

Oracle Packaging Folders

Object TypePackaging FolderNotes
CREATE/ALTER/DROP DATABASE LINK/sql_direct 
CREATE/ALTER/DROP FUNCTION/function Each function must be ended by a '/' on its own line.
CREATE/ALTER/DROP INDEX/ddl 
CREATE/ALTER/DROP PROCEDURE/procedureEach procedure must be ended by a '/' on its own line.
CREATE/ALTER/DROP QUEUE/sql_direct 
CREATE/ALTER/DROP SEQUENCE/ddl 
CREATE/ALTER/DROP SYNONYM/ddl Alternatively, use Datical Auto-Synonyms

CREATE/ALTER/DROP TABLE

/ddl 
CREATE/ALTER/DROP GLOBAL TEMPORARY TABLE/ddl
CREATE/ALTER/DROP MATERIALIZED VIEW/sql_direct
CREATE/ALTER/DROP TRIGGER

/trigger

Each trigger must be ended by a '/' on its own line.
CREATE/ALTER/DROP TYPE/sql_direct
CREATE/ALTER/DROP VIEW

/view

 
CREATE/ALTER/DROP VIEW INDEX/ddl
CREATE/ALTER/DROP CURSOR/sql_direct
CREATE/ALTER/DROP DIRECTORY/sql_direct
RENAME <DB_OBJECT>/sql_direct
OperationPackaging FolderNotes
INSERT, UPDATE, DELETE, SELECT/data_dml
GRANT, REVOKE/sql_directAlternatively, use Datical Auto-Permissions
  • No labels

Copyright © Datical 2012-2020 - Proprietary and Confidential