ORA-12058: materialized view cannot use prebuilt table
我们考虑到原表数据量的问题,采用 ON PREBUILT TABLE 参数建立物化视图。但是基于ROWID的物化视图不能建立在PREBUILT表上,不知道这是Oracle规定的,还是我试用的方法不对。想咨询一下,多谢帮助。SQL> CREATE MATERIALIZED VIEW USERA.TABLEA
3 REFRESH FORCE
4 WITH ROWID
5 AS SELECT * FROM USERB.TABLEB@DBLINK01 ;CREATE MATERIALIZED VIEW USERA.TABLEA
ON PREBUILT TABLE
REFRESH FORCE
WITH ROWID
AS SELECT * FROM USERB.TABLEB@DBLINK01 ORA-12058: materialized view cannot use prebuilt table
我们考虑到原表数据量的问题,采用 ON PREBUILT TABLE 参数建立物化视图。但是基于ROWID的物化视图不能建立在PREBUILT表上,不知道这是Oracle规定的,还是我试用的方法不对。想咨询一下,多谢帮助。SQL> CREATE MATERIALIZED VIEW USERA.TABLEA
3 REFRESH FORCE
4 WITH ROWID
5 AS SELECT * FROM USERB.TABLEB@DBLINK01 ;CREATE MATERIALIZED VIEW USERA.TABLEA
ON PREBUILT TABLE
REFRESH FORCE
WITH ROWID
AS SELECT * FROM USERB.TABLEB@DBLINK01 ORA-12058: materialized view cannot use prebuilt table
Cause: An attempt was made to use the prebuilt tables.
Action: Reissue the SQL command using BUILD IMMEDIATE or BUILD DEFERRED CREATE MATERIALIZED VIEW M_KAI BUILD IMMEDIATE AS SELECT * FROM M_KAI@cdltwn_connect;