1 2 Previous Next 15 Replies Latest reply: Oct 12, 2013 7:32 AM by ChuongNguyen RSS

    How to skip delete on logical standby

    ChuongNguyen

      Dear guys and gurus,


      On next month i will have plan to delete history data on my Primary database, but i still want to keep them in logical standby as the data warehouse. So, how can i skip delete statement from primary database apply to logical standby.


      Oracle SQL apply only support for Skip DML but not for keep delete statemen (on 10g and 11g)


      SQL>exec dbms_logstdby.skip(statement => 'DELETE',schema_name => 'SCOTT', object_name => 'DEPT');

      BEGIN dbms_logstdby.skip(statement => 'DELETE',schema_name => 'SCOTT', object_name => 'DEPT'); END;


        *

      ERROR at line 1:

      ORA-06550: line 1, column 7:

      PLS-00306: wrong number or types of arguments in call to 'SKIP'

      ORA-06550: line 1, column 7:

      PL/SQL: Statement ignored



      I do search and see one post about 3 years age about this question but still not answered.So, do you have any idea for this ???


      So thanks and best regards.


      Ch

        1 2 Previous Next