-
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*
-
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?
-
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*
-
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*
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|