DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2001

    Does dropping index invalidate procedures/Packages?

    Hi ,

    I am trying to recreate a problem that occured last week. One of the dba's dropped an Index (I can see from the logminer), and later we started seeing errors such as ORA-04061 existing state of string has been invalidated.

    I am trying to recreate a problem and find out what happened. But before I do it, I just wanted to check the forum if dropping an index on the table would invalidate the packages/procudures/indexes?

    There is always a better way to do the things.

  2. #2
    Join Date
    Nov 2000
    Off the top of my head, I don't think so. Something easy to check, though...
    Jeff Hunter
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.