Is it possible to do "select count(*) from sapr3.zpayr@QA2; " 2004-03-02 - By oracle-l-bounce@(protected)
Cool. It works.
So do I need to do "delete database link qa2 " to clean up?
Thanks.
--Roger
-- --Original Message-- --
From: oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)]
Sent: Tuesday, March 02, 2004 4:10 PM
To: oracle-l@(protected)
Subject: RE: Is it possible to do "select count(*) from
sapr3.zpayr@(protected); "
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@(protected)]
Sent: Tuesday, March 02, 2004 5:07 PM
To: oracle-l@(protected)
Subject: RE: Is it possible to do "select count(*) from
sapr3.zpayr@(protected); "
How to do it? Is there a document or links? Thanks.
-- --Original Message-- --
From: Igor Neyman [mailto:ineyman@(protected)]
Sent: Tuesday, March 02, 2004 4:01 PM
To: oracle-l@(protected)
Subject: RE: Is it possible to do "select count(*) from
sapr3.zpayr@(protected); "
You need a database link created between PR2 and QA2.
Igor Neyman, OCP DBA
ineyman@(protected)
-- --Original Message-- --
From: oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)] On Behalf Of Roger Xu
Sent: Tuesday, March 02, 2004 4:56 PM
To: Oracle-L@(protected) Org (E-mail)
Subject: Is it possible to do "select count(*) from sapr3.zpayr@(protected); "
>From SID=PR2, I failed to do the following:
SQL > select count(*) from sapr3.zpayr@(protected);
select count(*) from sapr3.zpayr@(protected)
*
ERROR at line 1:
ORA-02019 (See ORA-02019.ora-code.com): connection description for remote database not found
But I can do the following without any problems:
sqlplus system@(protected)/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@(protected)
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://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@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
For technical support please email tech_support@(protected) 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@(protected)
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://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@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
For technical support please email tech_support@(protected) 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@(protected)
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
