SQL> show parameter stream
streams_pool_size big integer 0
SQL> alter system set streams_pool_size =100m;
System altered.
SQL> alter database force logging;
Database altered.
SQL> alter database add supplemental log data;
Database altered.
SQL> alter table scott.dept
2 add supplemental log group log_group_dept
3 (deptno,dname,loc);
Table altered.
SQL> begin
2 dbms_capture_adm.prepare_table_instantiation(
3 table_name=>'scott.dept');
4 end;
5 /
PL/SQL procedure successfully completed.
SQL> begin
2 dbms_cdc_publish.create_change_set(
3 change_set_name=>'dept_cs',
4 description=>'hotlog change set for scott.dept',
5 change_source_name=>'HOTLOG_SOURCE',
6 stop_on_ddl=>'y',
7 begin_date=>sysdate,
8 end_date=>sysdate+1);
9 end;
10 /
begin
*
ERROR at line 1:
ORA-00258: manual archiving in NOARCHIVELOG mode must identify log
ORA-06512: at "SYS.DBMS_CAPTURE_ADM_INTERNAL", line 121
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_CDC_PUBLISH", line 560
ORA-06512: at line 2
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> SQL> SQL> startup mount
ORACLE instance started.
Total System Global Area 1224736768 bytes
Fixed Size 1279916 bytes
Variable Size 469764180 bytes
Database Buffers 738197504 bytes
Redo Buffers 15495168 bytes
Database mounted.
SQL> alter database archivelog;
Database altered.
SQL> alter database open;
Database altered.
SQL> begin
2 dbms_cdc_publish.create_change_set(
3 change_set_name=>'dept_cs',
4 description=>'hotlog change set for scott.dept',
5 change_source_name=>'HOTLOG_SOURCE',
6 stop_on_ddl=>'y',
7 begin_date=>sysdate,
8 end_date=>sysdate+1);
9 end;
10 /
PL/SQL procedure successfully completed.
SQL> begin
2 dbms_cdc_publish.create_change_table(
3 owner =>'cdcpub',
4 change_table_name=>'dept_ct',
5 change_set_name=>'dept_cs',
6 source_schema=>'scott',