...
| 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 | Yes | |
| CREATE/ALTER/DROP QUEUE | /sql_direct | Yes | |
| CREATE/ALTER/DROP SEQUENCE | /ddl | Yes | |
| CREATE/ALTER/DROP SYNONYM | /ddl | Yes | Alternatively, use Datical Auto-Synonyms |
CREATE/ALTER/DROP TABLE | /ddl | Yes | |
| CREATE/ALTER/DROP GLOBAL TEMPORARY TABLE | /ddl | 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 | 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 |