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

    How to skip delete on logical standby


      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.


        1 2 Previous Next