Announcement

Collapse
No announcement yet.

How to know the count of custom procedure in database..

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • How to know the count of custom procedure in database..

    How to know the count of custom procedure in database.. including count of procedures lying in custom packages.

  • #2
    In SQL Developer, View -> Reports --> TimesTen Reports -> All Objects -> Object Count by Type
    DB does not know which procedures are custom and which ones came along with OTM.

    Swapnil

    Comment


    • #3
      Hi Navya,

      Best practice in OTM is to keep any custom database/application objects naming convention like it should starts with XX
      So, it would be easy in future also to keep a track of those

      Previously, Oracle provides a count of OTM standard Database Objects in Installation Guide however, they have discontinued the same

      You can still check the Installation Guide for your OTM Version for more details

      Thank you


      -Prasad-
      Let's connect on LinkedIn
      Mobile: +91 973 049 6886
      E-mail: prasad.chandane@gmail.com

      If my post was helpful, then click on the Like button

      Comment

      Working...
      X