GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

problem when creating a materialized view with refresh fast option in 11gr2 (error ORA-00942: table

edited Dec 23, 2011 2:40AM in GoldenGate, Streams and Distributed Database (MOSC) 2 commentsAnswered
Hi all,i'm trying to create s materilized view over database link in my database 11gr2 :

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE    11.2.0.3.0      Production
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production

my database link is over a database in the same machine but in version 9.2.0.8

when i try to create a materilized view like this :

CREATE MATERIALIZED VIEW MV_NAME
TABLESPACE TBS
NOLOGGING
BUILD IMMEDIATE
USING INDEX TABLESPACE IDX_DBS
REFRESH COMPLETE
START WITH sysdate
NEXT SYSDATE+15/1440
WITH ROWID
AS
SELECT col1,col2,col3 FROM table_name@dblink;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center