oracle自带的cdc功能建的日志表,每晚22:00都会自动被清理掉,想关掉oracle自动清理的功能,求助建日志的脚本:----sys执行
grant select_catalog_role to zjpii_portal;
grant execute_catalog_role to zjpii_portal;
grant execute on dbms_cdc_publish to zjpii_portal;----zjpii_portal执行BEGIN
DBMS_CDC_PUBLISH.CREATE_CHANGE_SET(
change_set_name => 'zjpii_portal_change_set', --改变集
description => 'Change set for zjpii_portal info',
change_source_name => 'SYNC_SOURCE');
END;
begin
dbms_cdc_publish.create_change_table(
owner => 'zjpii_portal',
change_table_name => 'cg$t_jfoss_message',
change_set_name => 'zjpii_portal_change_set',
source_schema => 'zjpii_portal',
source_table => 't_jfoss_message',
column_type_list => '',
capture_values => 'both',
rs_id => 'y',
row_id => 'y',
user_id => 'n',
timestamp => 'n',
object_id => 'n',
source_colmap => 'n',
target_colmap => 'n',
options_string => 'tablespace tb02');
end;
/
grant select_catalog_role to zjpii_portal;
grant execute_catalog_role to zjpii_portal;
grant execute on dbms_cdc_publish to zjpii_portal;----zjpii_portal执行BEGIN
DBMS_CDC_PUBLISH.CREATE_CHANGE_SET(
change_set_name => 'zjpii_portal_change_set', --改变集
description => 'Change set for zjpii_portal info',
change_source_name => 'SYNC_SOURCE');
END;
begin
dbms_cdc_publish.create_change_table(
owner => 'zjpii_portal',
change_table_name => 'cg$t_jfoss_message',
change_set_name => 'zjpii_portal_change_set',
source_schema => 'zjpii_portal',
source_table => 't_jfoss_message',
column_type_list => '',
capture_values => 'both',
rs_id => 'y',
row_id => 'y',
user_id => 'n',
timestamp => 'n',
object_id => 'n',
source_colmap => 'n',
target_colmap => 'n',
options_string => 'tablespace tb02');
end;
/
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货