This discussion is archived
1 2 Previous Next 15 Replies Latest reply: Oct 12, 2013 5:32 AM by ChuongNguyen RSS

How to skip delete on logical standby

ChuongNguyen Newbie
Currently Being Moderated

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points