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-12008: error in materialized view refresh path in 10g

510293Mar 27 2008 — edited Oct 21 2008

Hi, all.

The database is on 10gr2.

I am testing materized view refresh.
However, I got the following errors.

----------------------------------------------------------------------------------
exec dbms_refresh.refresh('"STGFAB"."MV_OPTION_TEST_HO1"');

ORA-12008: error in materialized view refresh path
ORA-01008: not all variables bound
ORA-02063: preceding line from L8ZFAB
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2254
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2460
ORA-06512: at "SYS.DBMS_IREFRESH", line 683
ORA-06512: at "SYS.DBMS_REFRESH", line 195
ORA-06512: at line 1
----------------------------------------------------------------------------------

Thanks in advance.
Best Regards.

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 18 2008

Added on Mar 27 2008

#general-database-discussions

5 comments

3,601 views