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;
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;
0