Make objects Invalid, when valid
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Make objects Invalid, when valid

  1. #1
    Join Date
    Oct 2000
    Posts
    449
    Hello DBAs :

    If I have objects (procs, pkgs and functions) that are listed as valid under dba_objects when queries, how can I make them invalid... Any command ?? I dont want to bug the object and make them invalid by recompiling, coz, it's many objects that I want to invalidate.

    Thanks, ST2000

  2. #2
    Join Date
    Aug 2001
    Posts
    184
    im not exactly sure, but you can look at ?/rdbms/admin/utlip.sql to see how they do it.
    OCP DBA 8i
    ocpwannabe@yahoo.com
    -----------------------------
    When in doubt, pick 'C'.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width