Table of Contents |
---|
...
Operation and Object Type | Packaging Folders (fixed folders) | Package Methods (flexible folders) | Archived | Notes |
---|---|---|---|---|
CREATE/ALTER/DROP DATABASE LINK | sql_direct | direct | Yes | |
CREATE/ALTER/DROP FUNCTION | function | storedlogic | No | |
CREATE/ALTER/DROP INDEX |
| convert, ddl_direct, direct | Yes | |
CREATE/ALTER/DROP PROCEDURE | procedure | storedlogic | No | |
CREATE/ALTER/DROP QUEUE | sql_direct | direct | Yes | |
CREATE/ALTER/DROP SEQUENCE |
| convert, ddl_direct, direct | Yes | |
CREATE/ALTER/DROP SYNONYM |
| convert, ddl_direct, direct | Yes | For ALTER and CREATE OR REPLACE synonym only use ddl_direct or sql_direct/direct. (Do not use ddl/convert with ALTER and CREATE OR REPLACE synonym.) |
CREATE/ALTER/DROP TABLE |
| convert, ddl_direct, direct | Yes | |
CREATE/ALTER/DROP TRIGGER |
| storedlogic | No | |
CREATE/ALTER/DROP TYPE | sql_direct | direct | Yes | |
CREATE/ALTER/DROP VIEW |
| storedlogic | No | |
CREATE/ALTER/DROP VIEW INDEX |
| convert, ddl_direct, direct | Yes | |
RENAME <DB_OBJECT> | sql_direct | direct | Yes |
...
Operation | Packaging Folder (fixed folders) | Package Method (flexible folders) | Archived |
---|---|---|---|
INSERT, UPDATE, DELETE, SELECT | data_dml | data_dml | Yes |
GRANT, REVOKE | sql_direct | direct | Yes |
...