In an attempt to work around another problem, I have mistakenly dropped the underlying tables for a materialized view log, and now I can neither drop that log nor the MV relating to it. Our DBA says it's because those tables were manually dropped. Is there a way of either forcing the logs to be dropped in the absence of those tables or else recreate those tables?

Version Information:

Oracle Database 10g Enterprise Edition Release - 64bit
PL/SQL Release - Production
CORE  Production
TNS for Linux: Version - Production
NLSRTL Version - Production

1 Answer 1


Ok since there are no responses here.

I don't know if the problem was to do with the underlying tables or something else, we bounced the instance anyway. I also recreated the views using a SQL script (just create one for another table and use it as a template) and it seemed to work ok.

  • thanks for taking things into your own hands and sharing your solution Commented Oct 18, 2011 at 10:06

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.