alter system set java_pool_size = 50m;
BEGIN
dbms_cdc_publish.drop_change_set('source_change_set');
END;
BEGIN
DBMS_CDC_PUBLISH.CREATE_CHANGE_SET(change_set_name => 'source_change_set',
description => 'Change set for source table info',
change_source_name => 'SYNC_SOURCE');
END;
---需要额外安装JVM
---如果报错ORA-29538
/*解决方法
1.检查有没有安装JAVA组件
select * from v$option t where t.PARAMETER='Java';
如果返回行说明已安装,如果没有返回行,运行Oracle Universal Installer安装JAVA组件
2.如果在第1步返回行,则检查oracle中有没有dbms_java.
select distinct owner,name from dba_source where lower(NAME)='dbms_java';
如果没有返回行,执行第3步
3.在sqlplus下以sys登陆,执行$ORACLE_HOME/javavm/install/initjvm.sql
SQL>@?/javavm/install/initjvm.sql;
*/