Home » RDBMS Server » Server Administration » packages recompiling
packages recompiling [message #370265] Thu, 15 July 1999 07:26 Go to next message
naji
Messages: 5
Registered: May 1999
Junior Member
Hi,
how can i recompile all packages of a user (sys fro example).
Thanks
Re: packages recompiling [message #370270 is a reply to message #370265] Mon, 19 July 1999 11:00 Go to previous messageGo to next message
Chris Hunt
Messages: 27
Registered: March 1999
Junior Member
I don't know if there's a self-contained way of doing this (I've a feeling that there is, but can't put my finger on it) but this should work:
DECLARE
   CURSOR pack_cur IS
      SELECT object_type,owner,object_name
      FROM   all_objects
      WHERE  object_type LIKE 'PACKAGE%'
      AND    owner LIKE UPPER('&schema')
      ORDER BY object_name,object_type;
BEGIN
   FOR pack IN pack_cur LOOP
      DBMS_DDL.alter_compile (pack.object_type,
                              pack.owner,
                              pack.object_name);
   END LOOP;
END;
/

Hope you find it useful!

Chris

Re: packages recompiling [message #370278 is a reply to message #370265] Fri, 23 July 1999 13:40 Go to previous message
hmg
Messages: 40
Registered: March 1999
Member
In package dbms_utility exists the procedure

   dbms_utility.compile_schema(schema VARCHAR2);

But this procedure compiles all: functions, procedures and packages.

HMG
Previous Topic: Re: Sequence vs Rowid in primary key
Next Topic: Re: Dynamic variablenames?
Goto Forum:
  


Current Time: Fri Oct 23 16:23:46 CDT 2020