Calls
-
PROCEDURE DBMS_DDL.ALTER_COMPILE(typeIN VARCHAR2,schemaIN VARCHAR2,nameIN 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_nameIN VARCHAR2,table_schemaIN VARCHAR2 DEFAULT NULL,affected_schemaIN 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_nameIN VARCHAR2,table_schemaIN VARCHAR2 DEFAULT NULL,affected_schemaIN 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(typeIN VARCHAR2,schemaIN VARCHAR2,nameIN VARCHAR2,methodIN VARCHAR2,estimate_rowsIN NUMBER DEFAULT NULL,estimate_percentIN NUMBER DEFAULT NULL,method_optIN VARCHAR2 DEFAULT NULL,partnameVARCHAR2 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 ...