9
DBMS_DDL

This package provides access to some SQL data definition language (DDL) statements from stored procedures. It also provides special administration operations that are not available as DDLs.

The ALTER_COMPILE and ANALYZE_OBJECT procedures commit the current transaction, perform the operation, and then commit again.

This package runs with the privileges of the calling user, rather than the package owner SYS.

This chapter discusses the following topics:

• Summary of DBMS_DDL Subprograms