Oracle Database Discussions

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!

ORA-12899 when recreating materialized view

460592Mar 9 2010 — edited Jun 11 2010

Hi All,

I have a PL/SQL procedure to load data in partitioned base tables and a refreh force meterilized view to compute data from base partition table. I just droped the materialized view and try to recreate it.
I am facing an issue with Ora-12899 value too large for column "SYS".SNAP$".AUTO_FUN (actual: string 201, maximum: string 200).
I google and search in Metalink & Oracle forum for couple days but i didnt find a valuable solution.

Does you guy have some adivces for me to avoid this error.

Note: Before I can drop and re-create this materialized view without an error. I just faced this issue a few day ago.

TIA,
Lux

Edited by: lux2 on Mar 8, 2010 11:07 PM

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 9 2010

Added on Mar 9 2010

#general-database-discussions

11 comments

2,709 views