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

Thread: DBMS_SPACE compile with Error after Upgrade

  1. #1
    Join Date
    Jun 2002
    Location
    Longmont, Colorado
    Posts
    174

    DBMS_SPACE compile with Error after Upgrade

    I recently made an attempt to upgrade our 8163 (on Win2000) to 9205, following the steps included in Metalink Note: 159657.1 ("Complete Upgrade Checklist for Manual Upgrades from 8.x/9.0.1 to Oracle 9i") - which included an intermidiary step of upgrading to 8.1.7 first.

    Everything went well, but I have one object that won't compile - SYS.DBMS_SPACE.

    Does anyone why? or if this is exepcted?

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Since these belongs to sys schema, rerunning the catalog and catproc scripts may solve the problem.

    Thanx,
    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Jun 2002
    Location
    Longmont, Colorado
    Posts
    174
    The Metalink note I mentioned does say that the u0801070.sql script automatically calls the cat*.sql scripts. Whether that remains treu or not, while I manually ran catproc.sql (as suggested by sambavan), that fixed the problem.

    Thanks.

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