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!

Help in bringing in 4k Character column in Materialized View

3696948Sep 19 2018 — edited Sep 22 2018

Hello All,

Varchar2(4000 char)  is one of the columns definition of my base table. When I try to create materialized view on base table, it throws an error "ORA-00997: illegal use of LONG datatype"

Is there a way to bring in all 4k characters ? if not then we are ok to go down on character limit.

Thanks,

Nawaz
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 20 2018
Added on Sep 19 2018
24 comments
998 views