Take the 2-minute tour ×
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. It's 100% free, no registration required.

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 10.2.0.3.0 - 64bit
PL/SQL Release 10.2.0.3.0 - Production
CORE    10.2.0.3.0  Production
TNS for Linux: Version 10.2.0.3.0 - Production
NLSRTL Version 10.2.0.3.0 - Production
share|improve this question
add comment

1 Answer

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
add comment

Your Answer

 
discard

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.