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

Thread: DBMS_METADATA Package and Body

  1. #1
    Join Date
    Dec 2003
    Location
    West Texas
    Posts
    5

    DBMS_METADATA Package and Body

    Trying to get an export to work, but it tells me that the package body DBMS_METADATA has errors. The package DBMS_METADATA exists and is valid, but the DBMS_METADATA package body did not exist. I tried to create it from the package, but it will not validate and gives me a PLS-00103 error when I try.

    Does anyone know where in a script I can find the line that created this package and body in the first place? Catmeta.sql perhaps? That looks only to be creating the views though.
    Lonewolf *SH*

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    For package specification run dbmsmeta.sql.
    For package body run prvtmeta.plb.

    You'll find both files in $oracle_home\rdbms\admin
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  3. #3
    Join Date
    Dec 2003
    Location
    West Texas
    Posts
    5
    Awesome, this got me to the finish line

    I had to run the dbmsmeti.sql, dmbsmetu.sql, prvtmeti.plb and prvtmetu.plb scripts also, but then it worked fine.

    Thanks
    Lonewolf *SH*

  4. #4
    Join Date
    Dec 2003
    Location
    West Texas
    Posts
    5
    Now export gives the error

    identifier 'XDB.DBMS_XDBUTIL_INT' must be declared
    ORA-06550: line 1, column 1

    I have looked in the XDB schema but this object does not exist.
    Lonewolf *SH*

  5. #5
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    do you have any invalid objects? did you perhaps run catproc or catalog as system and not sys?
    I'm stmontgo and I approve of this message

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