| ORA-604 During dropping a Propagation [message #169841] |
Sat, 29 April 2006 05:11  |
Eisele
Messages: 2
Registered: April 2006
|
Junior Member |
|
|
I have strange problem with Streams:
Source: ORACLE 9.2.07. plus Patch 4285404
Target: ORACLE: 10.2.0.1
I, successfully create rules, a ruleset, capture and a propagation process, but no capturing took place, so I wanted to drop the rules, the ruleset, the capture and the propagation process, everthing was successfull, except dropping the propagation, I get the errormessage, which shown below.
I also include the definition of the db-link.
Any idea which would help me out there, would be greatly welcomed.
Regards,
Rüdiger
SQL> begin
2 DBMS_PROPAGATION_ADM.DROP_PROPAGATION(
3 propagation_name => 'PPV_STREAMS_PROPAGATION');
4 end ;
5 /
begin
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-00911: invalid character
ORA-06512: at "SYS.DBMS_LOGREP_UTIL", line 556
ORA-06512: at "SYS.DBMS_PROPAGATION_ADM", line 82
ORA-06512: at line 2
SQL> select * from dba_db_links where db_link like '%PPV%' ;
OWNER
------------------------------
DB_LINK
--------------------------------------------------------------------------------
USERNAME
------------------------------
HOST
--------------------------------------------------------------------------------
CREATED
--------
STRMADMIN
PPVDB.GLOBAL
STRMADMIN
OWNER
------------------------------
DB_LINK
--------------------------------------------------------------------------------
USERNAME
------------------------------
HOST
--------------------------------------------------------------------------------
CREATED
--------
ppvdb
29.04.06
SQL> show parameter db_domain
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_domain string global
SQL> show parameter global_name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
global_names boolean TRUE
SQL> select * from global_name
2 ;
GLOBAL_NAME
--------------------------------------------------------------------------------
WIZPROD1.GLOBAL
SQL>
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
