RE: Is it possible to do "select count(*) from sapr3.zpayr@QA2;"
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 2 Mar 2004 16:33:56 -0600
Cool. It works.
So do I need to do "delete database link qa2" to clean up?
Thanks.
--Roger
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]
Sent: Tuesday, March 02, 2004 4:10 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: Is it possible to do "select count(*) from
sapr3.zpayr@QA2;"
While connected to pr2:
create database link qa2 connect to system identified by manager using 'qa2';
That's one option. There are other variations on database links. See the
manual for more details.
-Mark
-----Original Message-----
From: Roger Xu [mailto:roger_xu@xxxxxxxxxxx]
Sent: Tuesday, March 02, 2004 5:07 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: Is it possible to do "select count(*) from
sapr3.zpayr@QA2;"
How to do it? Is there a document or links? Thanks.
-----Original Message-----
From: Igor Neyman [mailto:ineyman@xxxxxxxxxxxxxx]
Sent: Tuesday, March 02, 2004 4:01 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: Is it possible to do "select count(*) from
sapr3.zpayr@QA2;"
You need a database link created between PR2 and QA2.
Igor Neyman, OCP DBA
ineyman@xxxxxxxxxxxxxx
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Roger Xu
Sent: Tuesday, March 02, 2004 4:56 PM
To: Oracle-L@Freelists. Org (E-mail)
Subject: Is it possible to do "select count(*) from sapr3.zpayr@QA2;"
From SID=PR2, I failed to do the following:
SQL> select count(*) from sapr3.zpayr@QA2;
select count(*) from sapr3.zpayr@QA2
*
ERROR at line 1:
ORA-02019: connection description for remote database not found
But I can do the following without any problems:
sqlplus system@QA2/manager
SQL> select count(*) from sapr3.zpayr;
Thanks,
Roger
************************************************************************
This e-mail is intended solely for the person or entity to which it is
addressed and may contain confidential and/or privileged information.
Any review, dissemination, copying, printing or other use of this e-mail
by persons or entities other than the addressee is prohibited. If you
have received this e-mail in error, please contact the sender
immediately and delete the material.
************************************************************************
This email has been scanned for all viruses by the MessageLabs Email
Security System. Any questions please call 972-721-8257 or email your
request to tech_support@xxxxxxxxxxxx
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
For technical support please email tech_support@xxxxxxxxxxx or you can
call (972)721-8257.
This email has been scanned for all viruses by the MessageLabs Email Security
System.
************************************************************************
This e-mail is intended solely for the person or entity to which it is
addressed and may contain confidential and/or privileged information. Any
review, dissemination, copying, printing or other use of this e-mail by persons
or entities other than the addressee is prohibited. If you have received this
e-mail in error, please contact the sender immediately and delete the material.
************************************************************************
This email has been scanned for all viruses by the MessageLabs Email Security
System. Any questions please call 972-721-8257 or email your request to
tech_support@xxxxxxxxxxxx
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
For technical support please email tech_support@xxxxxxxxxxx or you can
call (972)721-8257.
This email has been scanned for all viruses by the MessageLabs Email Security
System.
************************************************************************
This e-mail is intended solely for the person or entity to which it is
addressed and may contain confidential and/or privileged information. Any
review, dissemination, copying, printing or other use of this e-mail by persons
or entities other than the addressee is prohibited. If you have received this
e-mail in error, please contact the sender immediately and delete the material.
************************************************************************
This email has been scanned for all viruses by the MessageLabs Email Security
System. Any questions please call 972-721-8257 or email your request to
tech_support@xxxxxxxxxxxx
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
