Hi Peter,
It works
Really appreciate your Prompt reply on this.
Thanks. Thanks...Thanks...............
If you have any document on the DB Link please forward me.
Suggest oracle book if any.
Once again Thanks!
Regards,
Yogesh Bhamre
-----Original Message-----
From: Peter Mutale Sunkutu [mailto:[Email address protected]
Sent: Saturday, September 29, 2007 4:34 PM
To: Yogesh Bhamre
Subject: RE: DB Link Creation
**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email,
**and removed any attachments, and kept your email address secret
**from this person, and any viruses/trojans.
**If you reply to this email, the person will see your email address as
normal
**Anything below this line is the original email text
Ok
Create a connection link in the tnsname.ora file on your ora91 database
to
point to the server with oracle 8i database. Use net configuration
assistant.
You will also need synonyms from the ora91 database pointing to table
you
want in ora8i.
On ora8i database you need to grant permission on those tables to a user
in
ora9i database
Using the synonyms that user will access the data.
Peter Mutale Sunkutu
Database Administrator
Finance Bank
P. O. Box 37102
Lusaka
Tel: +260211233306
Cell: +260955880096
-----Original Message-----
From: Yogesh Bhamre
[Email address protected]
Sent: Saturday, September 29, 2007 12:29 PM
To: LazyDBA Discussion
Subject: RE: DB Link Creation
Hi Peter,
Following is my test case:
Database Name RWYG RGEY
Server Server1 Server2
Version 9i 8i
I want to access tables of RGEY Database (user AIRAPPS) from RWYG
Database (user FAAS).
When I fired the following statement, I encounter the error as (TNS
Coulud not resolve service name).
CREATE PUBLIC DATABASE LINK "RGEY.WOLRD"
USING 'RGEY'
Please advice forward path.
-----Original Message-----
From: Peter Mutale Sunkutu [mailto:[Email address protected]
Sent: Saturday, September 29, 2007 3:43 PM
To: Yogesh Bhamre
Subject: RE: DB Link Creation
**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email,
**and removed any attachments, and kept your email address secret
**from this person, and any viruses/trojans.
**If you reply to this email, the person will see your email address as
normal
**Anything below this line is the original email text
You need to create a database link from oracle9i database.
Use
CREATE PUBLIC DATABASE LINK "DB1.WOLRD"
USING 'DB1'
This should help
-----Original Message-----
From: Yogesh Bhamre
[Email address protected]
Sent: Saturday, September 29, 2007 11:13 AM
To: LazyDBA Discussion
Subject: DB Link Creation
Hi all,
I want to create database link .
One of my database is in oracle 9i , Second in oracle 8i
I want to assess tables and views of oracle 8i from oracle 9i database
, so that I want to create db link ,
Please send me syntax of creating db link.
Thanks in advance.
Regards,
Yogesh
Disclaimer: Information transmitted by this e-mail is proprietary to
Adventity and/ or its Customers, intended for use only by the individual
or
entity to which it is addressed, and may contain information that is
privileged, confidential or exempt from disclosure under applicable law.
If
you are not the intended recipient or it appears that this mail has been
forwarded to you without proper authority, you are notified that any use
or
dissemination of this information in any manner is strictly prohibited.
In
such cases, please notify us immediately at [Email address protected]
and
delete this mail from your records.
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
--
This message has been scanned for viruses and dangerous content by
MailScanner, and is believed to be clean.
--
This message has been scanned for viruses and dangerous content by
MailScanner, and is believed to be clean.
Disclaimer: Information transmitted by this e-mail is proprietary to
Adventity and/ or its Customers, intended for use only by the individual
or
entity to which it is addressed, and may contain information that is
privileged, confidential or exempt from disclosure under applicable law.
If
you are not the intended recipient or it appears that this mail has been
forwarded to you without proper authority, you are notified that any use
or
dissemination of this information in any manner is strictly prohibited.
In
such cases, please notify us immediately at [Email address protected]
and
delete this mail from your records.
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
--
This message has been scanned for viruses and dangerous content by
MailScanner, and is believed to be clean.
--
This message has been scanned for viruses and dangerous content by
MailScanner, and is believed to be clean.
Disclaimer: Information transmitted by this e-mail is proprietary to Adventity and/ or its Customers, intended for use only by the individual or entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If you are not the intended recipient or it appears that this mail has been forwarded to you without proper authority, you are notified that any use or dissemination of this information in any manner is strictly prohibited. In such cases, please notify us immediately at [Email address protected] and delete this mail from your records.
Oracle LazyDBA home page