...
| Object Type | Packaging Folder | Archived? | Notes |
|---|---|---|---|
| CREATE/ALTER/DROP DATABASE LINK | sql_direct | Yes | |
| CREATE/ALTER/DROP FUNCTION | function | No | Use CREATE OR REPLACE rather than CREATE alone. Each function must be in its own file and end with a '/'. |
| CREATE/ALTER/DROP INDEX | | Yes | |
| CREATE/ALTER/DROP QUEUE | sql_direct | Yes | |
| CREATE/ALTER/DROP SEQUENCE | | Yes | |
| CREATE/ALTER/DROP PUBLIC SYNONYM | | Yes | Alternatively, use Datical Auto-Synonyms |
| CREATE/ALTER/DROP PRIVATE SYNONYM | | Yes | Alternatively, use Datical Auto-Synonyms |
CREATE/ALTER/DROP TABLE | | Yes | |
| CREATE/ALTER/DROP GLOBAL TEMPORARY TABLE | | Yes | |
| CREATE/ALTER/DROP MATERIALIZED VIEW | sql_direct | Yes | |
| CREATE/ALTER/DROP PACKAGE | package | No | Use CREATE OR REPLACE rather than CREATE alone. Each package must be in its own file and end with a '/'. |
| CREATE/ALTER/DROP PACKAGE BODY | packagebody | No | Use CREATE OR REPLACE rather than CREATE alone. Each package body must be in its own file and end with a '/'. |
| CREATE/ALTER/DROP PROCEDURE | procedure | No | Use CREATE OR REPLACE rather than CREATE alone. Each procedure must be in its own file and end with a '/'. |
| CREATE/ALTER/DROP TRIGGER |
| No | Use CREATE OR REPLACE rather than CREATE alone. Each trigger must be in its own file and end with a '/'. |
| CREATE/ALTER/DROP TYPE | sql_direct | Yes | Each type must be in its own file and end with a '/'. |
| CREATE/ALTER/DROP VIEW |
| No | Use CREATE OR REPLACE rather than CREATE alone. Each view must be in its own file and end with a '/'. |
| CREATE/ALTER/DROP VIEW INDEX | | Yes | |
| CREATE/ALTER/DROP CURSOR | sql_direct | Yes | |
| CREATE/ALTER/DROP DIRECTORY | sql_direct | Yes | |
| RENAME <DB_OBJECT> | sql_direct | Yes |
...