![](https://i-blog.csdnimg.cn/blog_migrate/200491d1ae6203cbdf7e02dca39a75b1.gif)
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 theglobal_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;