Hi
if i have 2 schemas in database1(globalname : db1.oracle.com)
User1 & user2
& there is another schema in database2(globalname : db2.oracle.com)
testuser
I am pulling data from database1(user1 & user2) to database2 (testuser)
so i am using database links
ideally database link naming convention mandates that we have the global name of the
database we want to connect to as the name of the database link
so in my case in database2 - testuser schema i create link like this
link name - db1.oracle.com connect to user1 identified by --- using '---'
it works fine
now i want a link to user2 schema in database 1
What name should i use for the link . i cant use db1.oracle.com as it is
already pointing to user1 schema
Kindly respond