invalid qualified SQL name

[m***@gmail.com]

I'm trying to configure multimaster replication. Here is what I do:

SQL> BEGIN
2 DBMS_REPCAT.ADD_MASTER_DATABASE (
3 gname => 'hand',
4 master => 'orcl_sms-222',
5 use_existing_objects => TRUE,
6 copy_rows => FALSE,
7 propagation_mode => 'ASYNCHRONOUS');
8 END;
9 /

This is the error I get:

*
ERROR at line 1:
ORA-44004: invalid qualified SQL name
ORA-06512: at "SYS.DBMS_REPCAT_UTL", line 4271
ORA-06512: at "SYS.DBMS_REPCAT_MAS", line 2156
ORA-06512: at "SYS.DBMS_REPCAT", line 146
ORA-06512: at line 2

Anyone know what's wrong?

Thanks.

[DA Morgan]

Post by m***@gmail.com
SQL> BEGIN
2 DBMS_REPCAT.ADD_MASTER_DATABASE (
3 gname => 'hand',
4 master => 'orcl_sms-222',
5 use_existing_objects => TRUE,
6 copy_rows => FALSE,
7 propagation_mode => 'ASYNCHRONOUS');
8 END;
9 /
*
ORA-44004: invalid qualified SQL name
ORA-06512: at "SYS.DBMS_REPCAT_UTL", line 4271
ORA-06512: at "SYS.DBMS_REPCAT_MAS", line 2156
ORA-06512: at "SYS.DBMS_REPCAT", line 146
ORA-06512: at line 2
Anyone know what's wrong?
Thanks.

It is impossible to know based on what you posted.

What version of Oracle (all four decimal places)?

But it is highly likely that the problem lies in line 3 or 4
of your code. Verify everything.

[f***@gmail.com]

Post by m***@gmail.com
SQL> BEGIN
2 DBMS_REPCAT.ADD_MASTER_DATABASE (
3 gname => 'hand',
4 master => 'orcl_sms-222',
ORA-44004: invalid qualified SQL name
ORA-06512: at "SYS.DBMS_REPCAT_UTL", line 4271
ORA-06512: at "SYS.DBMS_REPCAT_MAS", line 2156
ORA-06512: at "SYS.DBMS_REPCAT", line 146
ORA-06512: at line 2

You cannot use an arthmatic operator in a name; you used a minus