DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Missing Package Body

  1. 12-19-2000, 05:08 PM #1
    pthornburg
    pthornburg is offline Junior Member
    Join Date
    Apr 2000
    Location
    Keller, TX, USA
    Posts
    9

    Question

    We recently discovered during an attempted export that someone had deleted the Package Body for DBMS_SYS_SQL. The Package itself was still valid. We reran PRVTSQL.PLB (This is an Oracle 7.2.2.? database) and recreated the Package and Package Body.

    Someone else suggested it was dangerous to recreate just that package. What would you suggest?

    Thanks.
    pthornburg
    Reply With Quote Reply With Quote
  2. 12-19-2000, 05:52 PM #2
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    As long as nobody is using that package right now, I think that is a great idea.
    Jeff Hunter
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width