Help - Search - Members - Calendar
Full Version: REPLICATION
Oracle DBA Forums > Oracle > Oracle Forum
Vugar
I do alter database add supplemental log data , then when i execute

declaRE
BEGIN
DBMS_STREAMS_ADM.ADD_SCHEMA_RULES(
schema_name => 'SCOTT',
streams_type => 'CAPTURE',
streams_name => 'STREAM_CAPTURE',
queue_name => 'STRMADMIN.STREAMS_QUEUE',
include_dml => true,
include_ddl => true,
source_database => 'MASTER');
END;




i get error
ORA-01354: Supplemental log data must be added to run this command
ORA-06512: at "SYS.DBMS_STREAMS_ADM_UTL_INVOK", line 289
ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 439
ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 397
ORA-06512: at line 3

Please help me
JGarmany
You need to add the supplimental logging. This can be done at the table level or at the database level.

ALTER TABLE "JOHN"."BOOK_AUTHOR" ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY, FOREIGN KEY, UNIQUE INDEX) COLUMNS';

ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY, FOREIGN KEY, UNIQUE INDEX) COLUMNS';
Vugar
QUOTE (JGarmany @ Jul 7 2008, 10:36 PM) *
You need to add the supplimental logging. This can be done at the table level or at the database level.

ALTER TABLE "JOHN"."BOOK_AUTHOR" ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY, FOREIGN KEY, UNIQUE INDEX) COLUMNS';

ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY, FOREIGN KEY, UNIQUE INDEX) COLUMNS';



Please give me oracle replication example for schema mode , between two oracle database Please
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.