Oracle in a Nutshell

Calls

PROCEDURE DBMS_DDL.ALTER_COMPILE (type IN VARCHAR2, schema IN VARCHAR2, name IN VARCHAR2);

Recompiles the stored PL/SQL object name (case-sensitive) owned by schema of type type. A NULL schema uses the current schema. Valid values for type are PROCEDURE, FUNCTION, PACKAGE, PACKAGE BODY, and PACKAGE SPECIFICATION.

PROCEDURE DBMS_DDL.ALTER_TABLE_NOT_REFERENCEABLE (table_name IN VARCHAR2, table_schema IN VARCHAR2 DEFAULT NULL, affected_schema IN VARCHAR2 DEFAULT NULL);

Reverts references to object table_name by schema affected_schema from table_name owned by table_schema to the default. New with Oracle9i.

PROCEDURE DBMS_DDL.ALTER_TABLE_REFERENCEABLE (table_name IN VARCHAR2, table_schema IN VARCHAR2 DEFAULT NULL, affected_schema IN VARCHAR2 DEFAULT NULL);

Makes the object table owned by table_schema the table referenced from schema affected_schema for object name table_name. New with Oracle9i.

PROCEDURE DBMS_DDL.ANALYZE_OBJECT (type IN VARCHAR2, schema IN VARCHAR2, name IN VARCHAR2, method IN VARCHAR2, estimate_rows IN NUMBER DEFAULT NULL, estimate_percent IN NUMBER DEFAULT NULL, method_opt IN VARCHAR2 DEFAULT NULL, partname VARCHAR2 DEFAULT NULL);

Analyzes database object name owned by schema of type type (TABLE, INDEX, or CLUSTER) using option method (ESTIMATE, NULL, or DELETE). When method is ESTIMATE, you must specify either estimate_rows or estimate_percent to identify sample size. Additional analyze options specifiable by method_opt are FOR TABLE, FOR ALL COLUMNS [SIZE ...