| error in database link during propagation [message #270206] |
Wed, 26 September 2007 02:32  |
carthik7
Messages: 5
Registered: September 2007
|
Junior Member |
|
|
while executing the below propagation block, its throwing the below mentioned error.
BEGIN
DBMS_STREAMS_ADM.ADD_TABLE_PROPAGATION_RULES(
table_name => 'user1.ADDRESS',
streams_name => 'user1_propagation',
source_queue_name => 'strmadmin.user1_source_queue',
destination_queue_name => 'strmadmin.user1_target_queue@oracle@oracle',
include_dml => true,
include_ddl => false,
source_database => 'orcl',
inclusion_rule => true
);
END;
/
ERROR at line 1:
ORA-24045: invalid agent address strmadmin.user1_target_queue@oracle@oracle, agent address should be of the form [SCHEMA.]NAME[@DATABASE LINK]
I have created a dblink from source to target database as
CREATE DATABASE LINK oracle@oracle
CONNECT TO strmadmin
IDENTIFIED BY strmadmin
USING oracle;
where my global name is oracle and connection string is oracle.
Any fix or solution for this.
Thanks in advance
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
