Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

mdsys corruption

443542Jul 31 2007 — edited Jul 31 2007

This happened after I tried to do a datapump export of mdsys. Something got corrupted and now I can't use the datapump or drop users:

SQL> drop user mark cascade;
drop user mark cascade
*
ERROR at line 1:
ORA-04098: trigger 'MDSYS.SDO_TOPO_DROP_FTBL' is invalid and failed
re-validation

I've tried to recompile ever function and package that belongs to mdsys, and I've tried re-running the catmd.sql script. No improvement. Help?

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 28 2007

Added on Jul 31 2007

#general-database-discussions

2 comments

664 views