1 2 Previous Next 17 Replies Latest reply: Apr 3, 2012 7:32 AM by lunicon Go to original post RSS
      • 15. Re: publication with updateable view
        gwilkinson
        Where you are using views based on multiple tables in FAST refresh mode, you will need to create FAST refresh publication items on all of the tables (except the one defined as primary) in order for all changes to get picked up by the MGP process as changes (the select * from table where 1=2 is fine). Alternatively you can explore mycompose or queuebased pulication items both of which give better control of the processing
        • 16. Re: publication with updateable view
          lunicon
          GaryW wrote:
          ... you will need to create FAST refresh publication items on all of the tables (except the one defined as primary) in order for all changes to get picked up
          except the one defined as primary - what does this mean?
          what is primary table?

          2.4.1.3.1 Defining Publication Items for Updatable Multi-Table Views)
          <ul><li>The view must contain a parent table with a primary key defined.</li>
          <li>INSTEAD OF triggers must be defined for data manipulation language (DML) operations on the view.</li>
          <li><b>All base tables</b> of the view must be published.</li></ul>

          please explain...
          • 17. Re: publication with updateable view
            lunicon
            Bug 13887674 - CANT CREATE PUBLICATION ITEM OF VIEW WITH DISABLED PRIMARY KEY
            for example you cant create publication for view V_TESTDATA:

            CREATE TABLE TESTDATA (
            ID NUMBER(10) NOT NULL,
            DATA VARCHAR2(100),
            CONSTRAINT "TESTDATA_PK" PRIMARY KEY ("ID")
            );
            CREATE VIEW V_TESTDATA AS SELECT ID, DATA FROM TESTDATA;
            ALTER VIEW V_TESTDATA ADD CONSTRAINT V_TESTDATA_PK PRIMARY KEY ("ID") DISABLE;

            Download patch from metalink :)
            1 2 Previous Next