I have 2 instances. I want to view data in instance2, from instance1
I am at instance1, and i try to execute this:
select * from table@.dblink2
and i get ORA-02019, so i then i execute this on instance1:
select * from all_db_links;
Result:
Owner Username DB_link Host
PUBLIC|RHE |dblink2 |instance2|
So, whats missing, there is a DB link created from instance1 to instance2, so why am i not able to view the data from instance2 ??
Please respond ASAP.....Try setting the:
GLOBAL_NAMES=FALSE
parameter on both initSID1.ora and initSID2.ora files and re-start the instances.
Friday, February 17, 2012
DB Help!!
Labels:
database,
execute,
instance1,
instance1i,
instance2,
instances,
microsoft,
mysql,
oracle,
server,
sql,
tabledblink2and,
thisselect,
view
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment