Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: invalid qualified SQL name
mike7411_at_gmail.com wrote:
> 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.
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.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Thu Aug 31 2006 - 20:03:37 CDT