Share your knowledge! Login | Register
 
 
  Search     Advanced search
 

Home | Ask Question | Add tip | Questions | My tips | Recent tips & tricks | Suggest a category | FAQ | Forums

 
 
 
 Category : Home > Databases > Oracle > Security     

ORA-12015: cannot create a fast refresh materialized view from a complex query


Sponsored Links

Click here to Free Ebooks Download


Cause: Neither ROWIDs and nor primary key constraints are supported for complex queries.

Action: Reissue the command with the REFRESH FORCE or REFRESH COMPLETE option or create a simple materialized view.

  Sponsors
  Options
 
   del.icio.us  |  newsvine  |  digg  |  furl  |  google  |  yahoo  |  Ma.gnolia  |  vigillar  |  reddit  |  technorati  |  icerocket  |  pubsub

     (Average: 4.42 / Votes: 93)   Rate this tip:    

Start discussion or add comment to this tip

  Comments
Reply 1
Creation Of Materialized View Problem (Urgent)
The requirement as follows.
take a table:  Test1

Test1:
evntid        date
11            12-jan-2000
11            null
11            13-dec-2008
------------------------------------
12            10-jan-2010
12            30-nov-2014
12            20-feb-2013

Requirement is  Creation of Fast refresh MView with the following capabilities.
if u execute it like the following statement:
Select DECODE (COUNT(EVNTID),COUNT(DATE1),MAX(DATE1),NULL) FROM  TEST1 WHERE EVNTID=12 ;
it should return the value: 30-nov-2014

Select DECODE (COUNT(EVNTID),COUNT(DATE1),MAX(DATE1),NULL) FROM  TEST1 WHERE EVNTID=11;
it should return the value :     (null)

But for us the problem is The mview will not accept the analytic functions usage in Fast refresh Mview.


  Details
Tip reference : #103
views : 115254
Added on : 05/05/09
Submited by : Admin
 
Send a message Send a message Printer friendly output Printer friendly output
Display this member's tips Display this member's tips (180)
 
 
<< Previous Next >>
 Most viewed tips 
  Databases > Oracle > Security : How to unlock Oracle user account  
  Databases > Oracle > Performance Tuning : How to enable trace in Oracle  
  Operating Systems > Unix : How to kill Unix user session  
  Databases > Oracle : Kill user session  
   
  All categories
Databases | Programming | Hardware | Operating Systems | Networking | Internet | ERP / CRM | Games & Multimedia | Graphics & Design | Miscellaneous | Office Software | FAQ
 
 

Home |  FAQ |  Terms of Use |  Privacy Policy

© 2009 11gHelp.com