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.
For package specification run dbmsmeta.sql.
For package body run prvtmeta.plb.
You'll find both files in $oracle_home\rdbms\admin
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
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.
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.
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
Click Here to Expand Forum to Full Width