Skip to Main Content
Forums

SQL & PL/SQL

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!

What is the easiest way to alter a column type in materialized view?

3018678Dec 9 2015 — edited Dec 10 2015

Hello my dear friends,

I want to change a column type in a materialized view. NUMBER to VARCHAR2, so what do you recommend? What is the easiest way to do this?

Thanks
This post has been answered by Chris Hunt on Dec 9 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 7 2016
Added on Dec 9 2015
6 comments
2,613 views