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	Use CREATE OR REPLACE rather than CREATE alone. Each function must be in its own file and end with a '/'.
CREATE/ALTER/DROP INDEX	`ddl, ddl_direct, sql_direct`	convert, ddl_direct, direct	Yes
CREATE/ALTER/DROP QUEUE	`sql_direct`	direct	Yes
CREATE/ALTER/DROP SEQUENCE	`ddl, ddl_direct, sql_direct`	convert, ddl_direct, direct	Yes
CREATE/ALTER/DROP PUBLIC SYNONYM	`sql_direct`	direct	Yes	Alternatively, use Datical Auto-Synonyms.
CREATE/ALTER/DROP PRIVATE SYNONYM	`ddl, ddl_direct, sql_direct`	convert, ddl_direct, direct	Yes	Alternatively, use Datical Auto-Synonyms Note that for For ALTER and CREATE OR REPLACE only synonym use ddl_direct or sql_direct/direct. (Do not use ddl/convert with ALTER and CREATE OR REPLACE synonym.) Alternatively, use Datical Auto-Synonyms.
CREATE/ALTER/DROP TABLE	`ddl, ddl_direct, sql_direct`	convert, ddl_direct, direct	Yes
CREATE/ALTER/DROP GLOBAL TEMPORARY TABLE	`ddl, ddl_direct, sql_direct`	convert, ddl_direct, direct	Yes
CREATE/ALTER/DROP MATERIALIZED VIEW	`sql_direct`	direct	Yes
CREATE/ALTER/DROP PACKAGE	`package`	storedlogic	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`	storedlogic	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`	storedlogic	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	`trigger`	storedlogic	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`	direct	Yes	Each type must be in its own file and end with a '/'.
CREATE/ALTER/DROP VIEW	`view`	storedlogic	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	`ddl,` `ddl_direct,` `sql_direct`	convert, ddl_direct, direct	Yes
CREATE/ALTER/DROP CURSOR	`sql_direct`	direct	Yes
CREATE/ALTER/DROP DIRECTORY	`sql_direct`	direct	Yes
RENAME <DB_OBJECT>	`sql_direct`	direct	Yes

Operation	Packaging Folder (fixed folders)	Package Methods (flexible folders)	Archived?	Notes
INSERT, UPDATE, DELETE, SELECT	data_dml	data_dml	Yes
GRANT, REVOKE	sql_direct	direct	Yes	Alternatively, use Datical Auto-Permissions.

Error Handling

Do not put error-handling statements in the SQL scripts.

...

See also these pages for overview of packaging workflows, which packaging methods or folders to use for which types of changes, and SQL Parser for Oracle:

Overview of Packaging

Writing SQL Scripts for Datical DBLiquibase Enterprise

Fixed Folder Names

Flexible Folder Names

...