Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: invalid qualified SQL name

Re: invalid qualified SQL name

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 31 Aug 2006 18:03:37 -0700
Message-ID: <1157072617.219492@bubbleator.drizzle.com>


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.org
Received on Thu Aug 31 2006 - 20:03:37 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US