8
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 calling user, rather than the package owner SYS.

This chapter discusses the following topics:

• Summary of DBMS_DDL Subprograms

Summary of DBMS_DDL Subprograms

Table 8-1 DBMS_DDL Package Subprograms

Subprogram	Description
"ALTER_COMPILE Procedure"	Compiles the PL/SQL object.
"ANALYZE_OBJECT Procedure"	Provides statistics for the database object.