 DN Link error--Urgent [message #166786] |
Sat, 08 April 2006 07:52  |
rc_ashish
Messages: 39
Registered: June 2005
Location: mumbai
|
Member |
|
|
Hi,
I have 2 databases on oracle one is on 8i and another on 9i.
and i have created Db link on both database and i can view all tables of 8i from 9i through 9i but i can't view all tables of 9i from 8i.
I can see all sys views of 9i from 8i but not other users tables and data
Please give me solution urgently so i can view the 9i data from 8i through DB Link.
Thanks in Advance
Ashish
|
|
|
|
| Re: DN Link error--Urgent [message #166788 is a reply to message #166786] |
Sat, 08 April 2006 07:56  |
rc_ashish
Messages: 39
Registered: June 2005
Location: mumbai
|
Member |
|
|
In above topic, i have not wrote error so please refer following
query.
SQL> select * from arschema@abc;
select * from arschema@abc
*
ERROR at line 1:
ORA-00942: table or view does not exist
ORA-02063: preceding line from REMEDY
Thanks in Advance
Ashish
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
