Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
share|improve this question
up vote 1 down vote accepted

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.

share|improve this answer
thanks for taking things into your own hands and sharing your solution – Jack Douglas Oct 18 '11 at 10:06

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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