OraFAQ Forum: Server Administration » update remote database

Home » RDBMS Server » Server Administration » update remote database (

) 1 Vote

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

update remote database [message #435852]

Fri, 18 December 2009 07:21

anat1983
Messages: 6
Registered: December 2009

Junior Member

hello!
i am trying to update my table on remote database (sql server) and i have error:

UPDATE billing.pack_sub@billing SET sub_id = (select sub_id from subscriber)
*
ERROR at line 1:
ORA-00904: "SUB_ID": invalid identifier

i have this table:
SQL> desc billing.pack_sub@billing;
Name Null? Type
--------
sub_id NOT NULL NUMBER(10)
package_cost NUMBER(19,4)
phone_cost NUMBER(19,4)
sms_cost NUMBER(19,4)
multi_cost NUMBER(19,4)
is someone know what is the problem?
ty

Report message to a moderator

Re: update remote database [message #435876 is a reply to message #435852]

Fri, 18 December 2009 08:43

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.

post DDL for SUBSCRIBER

Report message to a moderator

Re: update remote database [message #435885 is a reply to message #435852]

Fri, 18 December 2009 09:34

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>i am trying to update my table on remote database (sql server) and i have error:
>UPDATE billing.pack_sub@billing SET sub_id = (select sub_id from subscriber)

Upon further review, I suspect the problem involves the case of the column name.

UPDATE billing.pack_sub@billing SET "sub_id" = (select sub_id from subscriber)

above SQL might work better, then again it might not.

Report message to a moderator