Skip to Main Content
Forums

Database Software

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Refresh materialized view fails : ORA-12008, ORA-12840

445048Jun 6 2005
Hi,
I'm trying to refresh a materialized view, but I've this error :

SQL> exec DBMS_SNAPSHOT.REFRESH('GEFINFO.CDD_MATVIEW');
BEGIN DBMS_SNAPSHOT.REFRESH('GEFINFO.CDD_MATVIEW'); END;

*
ERROR at line 1:
ORA-12008: error in snapshot refresh path
ORA-12840: cannot access a remote table after parallel/insert direct load txn
ORA-02063: preceding line from LIEN_GEF
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 654
ORA-06512: at line 1


The materialized view have been created like this, with no error :

CREATE MATERIALIZED VIEW GEFINFO.CDD_MATVIEW
TABLESPACE TBS_GEFINFO
REFRESH FORCE
WITH ROWID
AS
SELECT * FROM EFACHAT.CDD@lien_gef WHERE cmdexeeng >= f_date_debut_rafraich();


I use Oracle 8.1.7

Can you help me ?

Thanks in advance,
Nicolas

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 4 2005
Added on Jun 6 2005
#database-key-features, #replication
0 comments
1,831 views