ORA-12015 Error when creating Materialized View
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: ORA-12015 Error when creating Materialized View

  1. #1
    Join Date
    Sep 2000
    Posts
    362
    Hi,
    I get a ORA_12015 error when trying to create a view. I am using Oracle 8.1.7 EE on Windows 2000.

    SQL> create materialized view testview
    2 build immediate
    3 refresh fast
    4 enable query rewrite
    5 as
    6 select sum(actual) as sum_actual from test
    7 /
    select sum(actual) from test
    *
    ERROR at line 6:
    ORA-12015: cannot create a fast refresh snapshot from a complex query

    Thanks
    Anurag

  2. #2
    Join Date
    Mar 2000
    Location
    Chennai.Tamilnadu.India.
    Posts
    658

    Investigate

    Hi, 1st June 2001 12:50 hrs chennai

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

    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 snapshot.

    As per oracle Error message information.

    Give a try and back to this thread.

    Cheers

    Padmam

    Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width