Ora-26678 Streams capture process must be created first

Ora-26678 Streams capture process must be created first (文档 ID 395681.1)转到底部

---

修改时间:2010-10-3类型:PROBLEM

In this Document
  Symptoms
  Cause
  Solution

---

APPLIES TO:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 and later   [Release: 10.2 and later ]
Information in this document applies to any platform.

SYMPTOMS

Here is the error output .......... 
SQL> 
SQL> BEGIN 
2 DBMS_STREAMS_ADM.ADD_TABLE_RULES( 
3 table_name => '&THIS_USER&DOT&TAB1', 
4 streams_type => 'CAPTURE', 
5 streams_name => 'CAP_STREAMS', 
6 queue_name => '&queue_name', 
7 source_database => '&source_database', 
8 include_dml => true, 
9 include_ddl => true); 
10 END; 
11 / 
old 3: table_name => '&THIS_USER&DOT&TAB1', 
new 3: table_name => 'CITI_USER.CCS_CUSTOMER_EMAIL', 
old 6: queue_name => '&queue_name', 
new 6: queue_name => 'REP_USER.STREAMS_QUEUE', 
old 7: source_database => '&source_database', 
new 7: source_database => 'NEWYORK.TTI.COM', 

ORA-26678: Streams capture process must be created first 
ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 372 
ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 312 
ORA-06512: at line 2 

CAUSE

This problem typically occurs if the source_database_name is specified and it does NOT match the 
global_name of the local database. If the source_database_name does not match the global_name of 
the local database, it is assumed that downstream capture is being configured. ADD_TABLE_RULES 
can be used to add tables to downstream capture, but not to initially create the actual downstream capture process. 

SOLUTION

Make sure global_names of the source database matches  the global_name of the local database

You could check the GLOBAL_NAME from

connect / as sysdba

select * from global_name ;

change global_name :

alter database rename global_name to SELATRANS;