Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents

...

Operation and Object TypePackaging Folders (fixed folders)Package Methods (flexible folders)ArchivedNotes
CREATE/ALTER/DROP DATABASE LINKsql_directdirectYes
CREATE/ALTER/DROP FUNCTIONfunctionstoredlogicNo
CREATE/ALTER/DROP INDEXddl, ddl_direct, sql_directconvert, ddl_direct, directYes
CREATE/ALTER/DROP PROCEDUREprocedurestoredlogicNo
CREATE/ALTER/DROP QUEUEsql_directdirectYes
CREATE/ALTER/DROP SEQUENCEddl, ddl_direct, sql_directconvert, ddl_direct, directYes
CREATE/ALTER/DROP SYNONYMddl, ddl_direct, sql_directconvert, ddl_direct, directYesFor 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

ddl, ddl_direct, sql_directconvert, ddl_direct, directYes
CREATE/ALTER/DROP TRIGGER

trigger

storedlogicNo
CREATE/ALTER/DROP TYPEsql_directdirectYes
CREATE/ALTER/DROP VIEW

view

storedlogicNo
CREATE/ALTER/DROP VIEW INDEXddl, ddl_direct, sql_directconvert, ddl_direct, directYes
RENAME <DB_OBJECT>sql_directdirectYes

...

OperationPackaging Folder (fixed folders)Package Method (flexible folders)Archived
INSERT, UPDATE, DELETE, SELECTdata_dmldata_dmlYes
GRANT, REVOKEsql_directdirectYes

...