2 Replies Latest reply on Aug 23, 2019 9:27 AM by 3510875

    Editioned objects in 12c


      Hi Experts,


      Our version R12.2.5 with 12cr1 database


      Oracle says "Editioned objects cannot depend on non-editioned objects".But why it is allowing to create a view(editioned) on non-editioned object(ap_suppliers table)?


      SQL> create view xxdump AS SELECT vendor_id, vendor_name FROM ap.ap_suppliers;;

      View created.


      SQL> sho user

      USER is "APPS"



      Please correct me if my understanding is wrong