PL/SQL Package: DBMS_DDL

Provides access to some SQL Data Definition Language (DDL) statements from a stored procedure. It also provides special admin 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.

Subprocedures:

ALTER_COMPILE   Compile the PL/SQL object. 

ANALYZE_OBJECT  Provide statistics for the database object.

For full documentation of the packaged procedures above see the Oracle Manual:
"Oracle9i Supplied PL/SQL Packages and Types Reference"

or the book Oracle Built in Packages by Steven Feuerstein et al
Related Packages:

DBMS_UTILITY - Utility routines, Analyze etc
ANALYZE - Analyse Table | Index

Related Views:

                                                               INDEX_STATS
 DBA_PART_COL_STATISTICS  ALL_PART_COL_STATISTICS USER_PART_COL_STATISTICS 
 DBA_TAB_COL_STATISTICS   ALL_TAB_COL_STATISTICS  USER_TAB_COL_STATISTICS 
 DBA_USTATS               ALL_USTATS              USER_USTATS 
   


© Copyright SS64.com 1999-2014
Some rights reserved