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

    Editioned objects in 12c

    3510875

      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"

      SQL>

       

      Please correct me if my understanding is wrong