Home » SQL & PL/SQL » SQL & PL/SQL » Issue while creating Materialized View (10.2.0.3.0)
Issue while creating Materialized View [message #431645] Wed, 18 November 2009 21:42 Go to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member

Hi All,

While we are creating a materialized view we are getting the following error.

ORA-12018: following error encountered during code generation for "AP01MV01"."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[/email];

Can you please help us to resolve the issue and create the materialized views?

Thanks in advance

[Updated on: Wed, 18 November 2009 21:46]

Report message to a moderator

Re: Issue while creating Materialized View [message #431647 is a reply to message #431645] Wed, 18 November 2009 21:58 Go to previous messageGo to next message
Kevin Meade
Messages: 2101
Registered: December 1999
Location: Connecticut USA
Senior Member
Most people will tell you that any ORA sixhundred error = oracle support. I say it too.

With it said I would also note that most ora-600 errors that I have encountered had workarounds I could find. It usually involved code rewrites of one form or another.

In your case I see three things to investigate:

1) AS SELECT * FROM POLICES@PPM_DB_LINK[/email];

What is with [/email]?

2) you are build a materialized view from some remote database. Try making a copy of the table locally and creating the mview that way. This will tell you if there is some network issue involved.

3) read the documentation on mviews, then make sure your individual components are in the right order. Believe it or not, some of the expressions must come in a specific order of the mview statement will fail. For example, does WITH ROWID come before or after START WITH. Same question for all of the combinations.

Good luck, Kevin
Re: Issue while creating Materialized View [message #431649 is a reply to message #431647] Wed, 18 November 2009 22:05 Go to previous messageGo to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member

Kevin ,

There is no [/email]

By mistake it was there ....

Thanks ..
Re: Issue while creating Materialized View [message #431662 is a reply to message #431649] Wed, 18 November 2009 23:37 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
THis would not appear if you follow forum guide and post formatted and click on Preview button before posting.

Regards
Michel
Previous Topic: execute immediate error
Next Topic: Statistics time determination
Goto Forum:
  


Current Time: Sat Dec 10 16:58:04 CST 2016

Total time taken to generate the page: 0.07788 seconds