Issue while creating Materialized Views
639485Nov 18 2009 — edited Nov 18 2009Hi All,
While we are creating a materialized view we are getting the following error.
ORA-12018: following error encountered during code generation for "APMO01MV01"."PPM_Polices_MV"
ORA-00600: internal error code, arguments: [qkebCreateConstantOpn1], [], [], [], [], [], [], [], [], [], [], []
We are using the below code to create the materialized view. POLICES is a table name in our Database.
CREATE MATERIALIZED VIEW
PPM_POLICES_MV
REFRESH FAST
START WITH to_date('19-Nov-2009 06:00:00','dd-Mon-yyyy HH24:MI:SS')
NEXT SYSDATE+1
WITH ROWID
AS SELECT * FROM POLICES@PPM_DB_LINK;
Can you please help us to resolve the issue and create the materialized views?
Thanks in advance