Ramin Hossaini's Blog

14Apr/10

Recompile invalid objects in an Oracle schema

To compile all procedures, functions, packages, and triggers in a specific schema:

EXEC DBMS_UTILITY.compile_schema(SCHEMA => 'SCHEMA_NAME');

Related posts:

  1. Oracle: Basic user-logon auditing
  2. Update statistics on all objects in a database
  3. Search through files for a string (Linux)
  4. Basic Auditing in Oracle
  5. Oracle: Recycle listener.log
Tagged as: Leave a comment
Comments (0) Trackbacks (0)

No comments yet.


Leave a comment

(required)

No trackbacks yet.

» «

Pages

Categories

Bear