WARNING: This web is not used anymore. Please use PDBService.StreamsRecommendations instead! |
%capture_name%
', checkpoint_retention_time => 7);
%capture_name%
', '_checkpoint_frequency', ' %value%
');
%source_queue%
', ' %destination_db_link%
', destination_queue=>' %destination_queue%
', latency=>1);
%apply_name%
', ' %parameter%
', ' %value%
');
DBMS_CAPTURE_ADM.BUILD();
DBMS_CAPTURE_ADM.PREPARE_SCHEMA_INSTANTIATION( =%schema%= );
GRANT EXECUTE ON DBMS_APPLY_ADM TO strmadmin;
SET SERVEROUTPUT ON SIZE 1000000 EXEC print_errors
alter table system.logmr_restart_ckpt$ enable row movement; alter table system.logmr_restart_ckpt$ shrink space; alter table system.logmr_restart_ckpt$ disable row movement;
I | Attachment | History | Action | Size | Date | Who | Comment |
---|---|---|---|---|---|---|---|
![]() |
minimum_archivelog.sql | r1 | manage | 1.0 K | 2007-06-19 - 11:33 | EvaDafonte | |
![]() |
print_LCR.sql | r1 | manage | 5.1 K | 2007-06-19 - 11:34 | EvaDafonte | |
![]() |
shrink_logminer_tables.txt | r1 | manage | 3.7 K | 2009-06-16 - 11:33 | EvaDafonte | Script and job to shrink the logminer tables periodically |
![]() |
shrink_queue_tables.txt | r1 | manage | 4.1 K | 2009-06-16 - 11:34 | EvaDafonte | Script and job to shrink the queue tables periodically |