Tell me more ×
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.
up vote 2 down vote favorite

We changed the underlying table column size (length). So the materialized view which is built on that table throws an error now since the MV column still has the old size.

This is an Oracle 11gR2 database.

How can I change the MV column's length to match the table's new column size without dropping the MV and recreating it?

share|improve this question
Did you tried to compile the materialized view? alter materialized view <your_mv_here> compile – Fatih Keleş Dec 19 '12 at 20:31
i tried, the column size/length is still the same, not changed to the table's column new size/length... – magqq Dec 19 '12 at 21:09

migrated from stackoverflow.com Dec 19 '12 at 20:03

1 Answer

up vote 3 down vote

You have to drop and recreate.

If you look at the documentation here, you can see that only modification of the storage clauses are allowed.

share|improve this answer

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.